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

0 vote98 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote108 views1 answer
My sql data file extention
SQL
-1 vote161 views3 answers
MAKE TABLE FIT in oracle sql
SQL
9 votes110 views1 answer
Oracle get table schema
SQL
2 votes121 views1 answer
Query to find table size in oracle 12c
SQL
0 vote105 views1 answer
Exec procedure oracle
SQL
0 vote117 views1 answer
How to change mysql root password in windows 10
SQL
0 vote134 views1 answer
Mysql 3 months ago
SQL
0 vote136 views1 answer
Set classpath for mysql-connector.jar
SQL
1 vote101 views1 answer
How to see logical reads in sql server
SQL