select CURRENT_TIMESTAMP
or
select LOCALTIMESTAMP
the first has the information with the timezone offset at the end,
whereas the second does not.
________________________________
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Negandhi, Nishith
Sent: Thursday, January 18, 2007 3:43 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] System Date
Hi,
How to check the system date using PG/SQL ??