Jump to: navigation, search

PostgreSQL LOCALTIMESTAMP

From w3cyberlearnings

Contents

Postgresql localtimestamp

Returns current date and time.

Syntax localtimestamp

localtimestamp;

Example 1


postgres=# SELECT localtimestamp;
         timestamp          
----------------------------
 2012-06-16 23:51:06.949532
(1 row)

postgres=# SELECT localtimestamp;
         timestamp         
---------------------------
 2012-06-16 23:51:14.94475
(1 row)

Example 2

Related Links



Navigation
Web
SQL
MISC
References