postgres datetime now
/* The NOW() function returns the current date and time. The return type of the NOW() function is the timestamp with time zone. See the following example:*/ SELECT NOW(); /*-------------------------------*/ 2017-03-18 08:21:36.175627+07 /* Note that the NOW() function returns current date and time based on the database server’s time zone setting.*/