Jump to: navigation, search

PostgreSQL NOW

From w3cyberlearnings

Contents

Postgresql now

Return current date and time with time zone.

Syntax now

now();

Example 1

postgres=# SELECT now();
              now              
-------------------------------
 2012-06-16 23:52:58.786413-04
(1 row)

postgres=# SELECT now();
              now              
-------------------------------
 2012-06-16 23:53:23.229155-04
(1 row)

Example 2

Related Links



Navigation
Web
SQL
MISC
References