TRUNC Date function

Truncates a timestamp and returns a date.

Syntax

TRUNC(timestamp)

Arguments

timestamp

A timestamp column or an expression that implicitly converts to a timestamp.

To return a timestamp value with 00:00:00 as the time, cast the function result to a TIMESTAMP.

Return type

DATE

Examples

The following example returns the date portion from the result of the SYSDATE function (which returns a timestamp).

select sysdate;

timestamp
----------------------------
2011-07-21 10:32:38.248109
(1 row)

select trunc(sysdate);

trunc
------------
2011-07-21
(1 row)

The following example applies the TRUNC function to a TIMESTAMP column. The return type is a date.

select trunc(starttime) from event
order by eventid limit 1;

trunc
------------
2008-01-25
(1 row)