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






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

1.Get current time for logging
2.SELECT now()