Database Management Systems
In MariaDB, you can use the TIMESTAMPDIFF() function to calculate a person’s age (or the age of anything for that matter).
TIMESTAMPDIFF() is a built-in date and time function that returns the difference between two date or datetime expressions. Passing YEAR as the first argument, date of birth as the second argument, and the current date as the third, will return the age in years.
In Oracle Database, the ASCIISTR() function returns an ASCII version of the given string in the database character set.Â
Below are two functions that can be used to return the day from a date in Oracle Database.
Continue readingI recently tried to install QEMU on my M1 Mac but received the “Cannot install in Homebrew on ARM processor in Intel default prefix” error.
Here’s how I fixed the issue.
Continue readingBelow is a full list of datetime functions available in Oracle Database.
Continue readingIn Oracle Database, the TRUNC(date) function returns the given date value with the time portion of the day truncated to the unit provided in the specified format model.
Oracle also has a TRUNC(number) syntax, which is used on numbers. This article is solely about the TRUNC(date) syntax, which is used on dates.
In Oracle Database, the TO_YMINTERVAL() function converts its argument to a value of INTERVAL MONTH TO YEAR data type.
In Oracle Database, the SYS_EXTRACT_UTC() function extracts the UTC (Coordinated Universal Time) from a datetime value with time zone offset or time zone region name.
In Oracle Database, the GREATEST() function returns the greatest of a list of one or more expressions.
In Oracle Database, the LEAST() function returns the least of a list of one or more expressions.