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)