Date functions

DATETIME function

The DATETIME function combines the features of both DATE and TIME functions. It displays both date and time together.

The time shown by DATETIME is UTC time by default. If we want to display the local time, we can add a parameter ‘localtime’ to the DATETIME function.

The ‘Now’ parameter in DATETIME function is case-insensitive. ‘NOW’ and ‘now’ would produce the same result as ‘Now’.