PostgreSQL CLOCK TIMESTAMP
From w3cyberlearnings
Contents |
Postgresql clock_timestamp
This function returns the current date and time.
Syntax clock_timestamp
clock_timestamp();
Return
Return timestamp with time zone.
Example 1
postgres=# SELECT clock_timestamp();
clock_timestamp
-------------------------------
2012-06-16 07:06:06.451839-04
(1 row)
postgres=# SELECT clock_timestamp();
clock_timestamp
-------------------------------
2012-06-16 07:18:54.582446-04
(1 row)
Example 2
Related Links
- age
- clock_timestamp
- current_date
- current_time
- current_timestamp
