Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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.*/
Source by www.postgresqltutorial.com #
 
PREVIOUS NEXT
Tagged: #postgres #datetime
ADD COMMENT
Topic
Name
5+7 =