Jump to: navigation, search

PostgreSQL TIMEOFDAY

From w3cyberlearnings

Contents

Postgresql timeofday

Returns current date and time as a string. Similar to PostgreSQL CLOCK TIMESTAMP.

Syntax timeofday

 timeofday();

Example 1

postgres=# SELECT timeofday();
              timeofday              
-------------------------------------
 Sun Jun 17 00:45:15.036850 2012 EDT
(1 row)

postgres=# SELECT timeofday();
              timeofday              
-------------------------------------
 Sun Jun 17 00:45:32.160116 2012 EDT
(1 row)

Related Links



Navigation
Web
SQL
MISC
References