In MariaDB, the SYSDATE() and NOW() functions are similar in that they return the current date and time.
However, there is an important difference: SYSDATE() returns the time that it executes, whereas NOW() returns the time that the statement started executing.
And when run within a stored procedure or trigger, SYSDATE() will return the time that it executes, whereas NOW() will return the time that the stored procedure or trigger started executing.
In Oracle Database, the TO_DATE() function converts its argument to a value of DATE data type.
Below are two functions that can be used to extract the month from a date in Oracle Database.
Continue readingMariaDB provides a WEEKDAY() function and a DAYOFWEEK() function, both of which return the day of the week, represented as a number.
But the number returned is different between these functions.
This post looks at the difference.
Continue readingBelow are two functions that can be used to return the day from a date in Oracle Database.
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 TO_TIMESTAMP() function converts its argument to a value of TIMESTAMP data type.