Select todays data postgres query

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)

Source: postgresqltutorial.com

Postgresql get date now

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

Source: postgresqltutorial.com

Similar codes

7 votes253 views4 answers
Index in mysql
SQL
6 votes216 views3 answers
Mysql server is not starting xampp
SQL
0 vote220 views1 answer
Where case insensitive like mysql
SQL
5 votes237 views2 answers
Sql server port number
SQL
1 vote229 views1 answer
Mysql show database size in mb
SQL
0 vote233 views1 answer
Restart sql server command line linux
SQL
3 votes238 views1 answer
Oracle list user grants
SQL
0 vote255 views2 answers
How to install psql in ubuntu
SQL
9 votes433 views2 answers
Current date in postgresql minus 1 day
SQL
8 votes236 views2 answers
Mysql get first x characters
SQL