/SQL/Date_trunc postgres

Date_trunc postgres

Postgresql today - 1 year

select now() - INTERVAL '1 YEAR';

3

Date_trunc postgres

SELECT DATE_TRUNC('hour', TIMESTAMP '2017-03-17 02:09:30');

2

Source: postgresqltutorial.com

Psql datetime grather than

SELECT *
FROM table
WHERE update_date >= '2013-05-03'::date
AND update_date < ('2013-05-03'::date + '1 day'::interval);

1

Source: stackoverflow.com

Similar codes

0 vote342 views1 answer
How to to get current date and time in sql
SQL
1 vote399 views1 answer
Mysql take number in string
SQL
8 votes361 views1 answer
Oracle add months to sysdate
SQL
0 vote342 views1 answer
How to connect to mysql in ef 6
SQL
0 vote358 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
15 votes339 views2 answers
How to know the username of postgresql
SQL
5 votes368 views1 answer
How to get all dates in a month in oracle
SQL
1 vote365 views1 answer
Altering the column name in MySQL to have a default value
SQL
3 votes432 views1 answer
Where id is in list sql
SQL
1 vote352 views2 answers
Mysql current user
SQL

Share