On Tue, Aug 21, 2012 at 10:12 PM, Scott Marlowe <[email protected]> wrote: > On Tue, Aug 21, 2012 at 10:08 PM, Scott Marlowe <[email protected]> > wrote: >> On Tue, Aug 21, 2012 at 3:29 PM, Michael Clark <[email protected]> wrote: >>> For example, if I insert like so: >>> INSERT INTO sometable (startdate) values ('1750-08-21 21:17:00+00:00'); >> >> What's the reason for you inserting with an offest instead of letting >> the client timezone set it for you? Just wondering. > > Note that if you just want to get out what you're putting in (GMT) you > can do this: > > select startdate at time zone 'GMT' from sometable ; > timezone > --------------------- > 1750-08-21 21:17:00
Or you could just use plain timezones, not timezones with timestamp. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
