Postgres Pro
Downloads
Home   >   mailing lists

now() AT TIME ZONE 'GMT'; - Mailing list pgsql-general

From Richard Emberson
Subject now() AT TIME ZONE 'GMT';
Date
Msg-id 3CB221C6.CEA73711@phc.net
Whole thread Raw
Responses Re: now() AT TIME ZONE 'GMT';
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: vacuuming not working?
Next
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: Tcl_CreateSlave error (pg 7.1.2, RH 7.2)