Skip site navigation (1) Skip section navigation (2)

Re: DST and time zones

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: A Gilmore <agilmore(at)shaw(dot)ca>
Cc: Postgresql Mailing list <pgsql-novice(at)postgresql(dot)org>
Subject: Re: DST and time zones
Date: 2004-09-19 03:03:28
Message-ID: 15258.1095563008@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
A Gilmore <agilmore(at)shaw(dot)ca> writes:
> I have table holding timestamps without a time zone (considered GMT). 
> Ill being making inserts into this table with a timestamp like 3pm PST, 
> which I need to be translated and inserted as GMT.  Later this will 
> likely be queried where I need the timestamp returned for say EST.

This would all work a lot better if the column were timestamp *with*
timezone.  Trying to do it the way you are is just swimming upstream
to no particular purpose.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Kumar SDate: 2004-09-20 02:15:21
Subject: Creating a new column with SERIAL as data type
Previous:From: A GilmoreDate: 2004-09-19 01:11:11
Subject: Re: DST and time zones

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group