Mega Code Archive

 

Categories / PostgreSQL / Date Timezone

 

Date_trunc(minute, now())

postgres=# SELECT date_trunc('minute', now());        date_trunc ------------------------  2006-10-08 15:12:00-07 (1 row) postgres=#