SQL

postgresql get date now

If you want get the current date and time without timezone, you can cast it explicitly as follows:

SELECT NOW()::timestamp;
            now
----------------------------
 2017-03-17 18:37:29.229991
(1 row)
Code language: SQL (Structured Query Language) (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.*/

postgresql get today

SELECT CURRENT_DATE;

postgresql get date now

SELECT NOW();
              now
-------------------------------
 2017-03-18 08:21:36.175627+07