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