now() AT TIME ZONE 'GMT';

From: Richard Emberson <emberson(at)phc(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: now() AT TIME ZONE 'GMT';
Date: 2002-04-08 23:03:34
Message-ID: 3CB221C6.CEA73711@phc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


If I want a column to have a default TIMESTAMP of 'now' but not in PST
timezone but GMT,
is the best way of doing it the following:

change_time TIMESTAMP DEFAULT now() AT TIME ZONE 'GMT' NOT NULL,

Richard

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= 2002-04-08 23:20:21 Re: Tcl_CreateSlave error (pg 7.1.2, RH 7.2)
Previous Message Tom Lane 2002-04-08 21:35:58 Re: vacuuming not working?

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2002-04-08 23:38:31 Re: timeout implementation issues
Previous Message Bruce Momjian 2002-04-08 21:15:41 Re: timeout implementation issues