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 ??

Reply via email to