NOW ( )

Returns the current local date and time as a timestamp value in this format:

‘yyyy-mm-dd hh:mm:ss.mmm’

Uses the local clock time by default. If SET TIME ZONE has been called, then the value of NOW() is determined by calculating UTC time/date from the system clock and operating system locale setting, then adding the displacement value specified with SET TIME ZONE.

Thursday, 18 April 2019 Posted in Time and Date Functions