Mega Code Archive

 

Categories / PostgreSQL / Date Timezone

 

Now()

postgres=# postgres=# SELECT current_timestamp, now() AS timestamp;             now             |         timestamp ----------------------------+----------------------------  2006-10-08 15:11:40.109-07 | 2006-10-08 15:11:40.109-07 (1 row) postgres=#