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.
Note: localtime is local time of the server where the query is executed. The SQL server used in Bigbinary Academy is set in UTC time zone. So, the local time shown in this editor will be UTC time.
The 'Now' parameter in DATETIME function is case-insensitive.
'NOW' and 'now' would produce the same result as 'Now'.