PostgreSQL DATE TRUNC
From w3cyberlearnings
Contents |
Postgresql date_trunc
This function returns the field value from the expression (date, timestamp, or interval)
Syntax date_trunc
- field: sets the field name
- expre: date, or datetime expression
date_trunc(field, expre);
Field
- microseconds
- milliseconds
- second
- minute
- hour
- day
- week
- month
- quarter
- year
- decade
- century
- millennium
Example 1
postgres=# SELECT date_trunc('day',timestamp '2015-03-10 10:50:30'); date_trunc --------------------- 2015-03-10 00:00:00 (1 row) postgres=# SELECT date_trunc('minute',timestamp '2015-03-10 10:50:30'); date_trunc --------------------- 2015-03-10 10:50:00 (1 row)
Example 2
postgres=# SELECT name, age, date_trunc('month',age) FROM employee; name | age | date_trunc --------+------------+------------------------ John | 1990-04-13 | 1990-04-01 00:00:00-06 Week | 1991-06-12 | 1991-06-01 00:00:00-05 Christ | 1995-05-17 | 1995-05-01 00:00:00-05 (3 rows)
Related Links
- date_part
- date_trunc
- extract
- isfinite
- justify_days