/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

1 vote327 views2 answers
Create table if not exist
SQL
0 vote310 views1 answer
Sql orcale i forgot what my name & password was
SQL
2 votes319 views2 answers
How to view created temporary tables in mysql
SQL
9 votes325 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote338 views1 answer
How change the field place in mysql
SQL
2 votes327 views1 answer
Set username and password for postgresql database
SQL
21 votes340 views1 answer
SQL cheat sheet pdf
SQL
6 votes326 views2 answers
Database url postgres
SQL
0 vote343 views3 answers
Fetlife
SQL
0 vote319 views1 answer
Is not sql
SQL

Share