Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with timestamp with time zone and old dates? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Problems with timestamp with time zone and old dates?
Date
Msg-id CAOR=d=1Bvjp=hZi-q24sG0nzasTxu=jxqJcsVSfAqftAOO5o5w@mail.gmail.com
Whole thread Raw
In response to Problems with timestamp with time zone and old dates?  (Michael Clark <codingninja@gmail.com>)
Responses Re: Problems with timestamp with time zone and old dates?  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
On Tue, Aug 21, 2012 at 3:29 PM, Michael Clark <codingninja@gmail.com> 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.

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Are there any options to parallelize queries?
Next
From: Scott Marlowe
Date:
Subject: Re: Problems with timestamp with time zone and old dates?