TIMESTAMP_TRUNC
Truncates the specified TIMESTAMP. If you omit the precision argument, TIMESTAMP_TRUNC
truncates to day (DD
) precision.
Behavior Type
Syntax
TIMESTAMP_TRUNC( trunc‑target[, 'precision'] )
Parameters
trunc‑target |
An expression that evaluates to one of the following data types: |
precision |
A string constant that specifies precision for the truncated value, one of the following:
Note: Hour, minute, and second truncating is not supported by |
Examples
Truncate to the current hour:
=> SELECT TIMESTAMP_TRUNC(CURRENT_TIMESTAMP, 'HH'); TIMESTAMP_TRUNC --------------------- 2016-04-29 08:00:00 (1 row)
Truncate to the month:
=> SELECT TIMESTAMP_TRUNC('9-22-2011 12:34:00'::TIMESTAMP, 'MM'); TIMESTAMP_TRUNC --------------------- 2011-09-01 00:00:00 (1 row)