Answers for "get date in postgresql"

SQL
1

postgresql get date from datetime

SELECT DATE(column_name) FROM table_name;
Posted by: Guest on December-07-2020
0

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)
Posted by: Guest on October-08-2021
0

postgresql get date now

SELECT NOW();
              now
-------------------------------
 2017-03-18 08:21:36.175627+07
Posted by: Guest on October-08-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language