Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id F2F639FB2C9 for ; Thu, 18 Jan 2007 19:56:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 62718-09 for ; Thu, 18 Jan 2007 19:56:16 -0400 (AST) X-Greylist: delayed 00:25:13.177457 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id D03489FB1A5 for ; Thu, 18 Jan 2007 19:56:20 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.illumen.com (unknown [64.207.29.137]) by svr4.postgresql.org (Postfix) with ESMTP id D22675AFA29 for ; Thu, 18 Jan 2007 23:31:06 +0000 (GMT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C73B58.B8B90E1C" Subject: Re: System Date X-MimeOLE: Produced By Microsoft Exchange V6.5 Date: Thu, 18 Jan 2007 16:31:04 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] System Date Thread-Index: Acc7UgCWH9j2NyQUSzq/oNo7LqMNMwABpX8w References: From: "Benjamin Krajmalnik" To: "Negandhi, Nishith" , X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.517 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_MESSAGE, SPF_SOFTFAIL X-Spam-Level: X-Archive-Number: 200701/163 X-Sequence-Number: 24319 This is a multi-part message in MIME format. ------_=_NextPart_001_01C73B58.B8B90E1C Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable select CURRENT_TIMESTAMP =20 or=20 =20 select LOCALTIMESTAMP =20 the first has the information with the timezone offset at the end, whereas the second does not. ________________________________ From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Negandhi, Nishith Sent: Thursday, January 18, 2007 3:43 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] System Date=20 =09 =09 Hi, How to check the system date using PG/SQL ?? ------_=_NextPart_001_01C73B58.B8B90E1C Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable
select CURRENT_TIMESTAMP
 
or
 
select LOCALTIMESTAMP
 
the first has the information with the timezone = offset at=20 the end, whereas the second does not.


From: = pgsql-admin-owner@postgresql.org=20 [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of = Negandhi,=20 Nishith
Sent: Thursday, January 18, 2007 3:43 = PM
To:=20 pgsql-admin@postgresql.org
Subject: [ADMIN] System Date=20

Hi,
How to check the system date using = PG/SQL=20 ??
------_=_NextPart_001_01C73B58.B8B90E1C--