Thread: Rounding datetimes

Is there a way to round an interval to the nearest minute or do I need
to create a function for this?

date_trunc('minute',interval)

see

http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC

Peter Childs

jws wrote:
> Is there a way to round an interval to the nearest minute...

Yes. See date_trunc function. Of course this truncates down to the
specified unit. If you want to round up/down to the nearest minute I
suppose you could just add '30 seconds'::interval before truncating.

select
now(),
date_trunc('minute', now()),
date_trunc('minute', now()+'30 seconds'::interval);

-[ RECORD 1 ]-----------------------------
now        | 2007-05-22 10:25:37.706279-07
date_trunc | 2007-05-22 10:25:00-07
date_trunc | 2007-05-22 10:26:00-07


Cheers,
Steve