now(): get current date and time : now « Date Timezone « PostgreSQL

1. PostgreSQL
2. Date Timezone
3. now

now(): get current date and time

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=#
           
       

Related examples in the same category