Re: [GENERAL] Problems with timestamp with time zone and old dates?

2012-08-23 Thread Michael Clark
On Wed, Aug 22, 2012 at 5:00 AM, hubert depesz lubaczewski < dep...@depesz.com> wrote: > On Tue, Aug 21, 2012 at 05:29:14PM -0400, Michael Clark wrote: > > For example, if I insert like so: > > INSERT INTO sometable (startdate) values ('1750-08-21 21:17:00+00:00'); > > > > I get the following when

Re: [GENERAL] Problems with timestamp with time zone and old dates?

2012-08-23 Thread Michael Clark
HI Scott. Thanks a lot for the feedback. I ended up setting the client time zone to GMT on my connections, and that has "fixed" the problem for us. It's actually an awesome solution, we can now expect all timestamps to be returned in a consistent fashion. Thanks for prodding me on that and sendin

Re: [GENERAL] Problems with timestamp with time zone and old dates?

2012-08-22 Thread hubert depesz lubaczewski
On Tue, Aug 21, 2012 at 05:29:14PM -0400, Michael Clark wrote: > For example, if I insert like so: > INSERT INTO sometable (startdate) values ('1750-08-21 21:17:00+00:00'); > > I get the following when I select: > SELECT startdate FROM sometable; > startdate > ---

Re: [GENERAL] Problems with timestamp with time zone and old dates?

2012-08-21 Thread Scott Marlowe
On Tue, Aug 21, 2012 at 10:12 PM, Scott Marlowe wrote: > On Tue, Aug 21, 2012 at 10:08 PM, Scott Marlowe > wrote: >> On Tue, Aug 21, 2012 at 3:29 PM, Michael Clark wrote: >>> For example, if I insert like so: >>> INSERT INTO sometable (startdate) values ('1750-08-21 21:17:00+00:00'); >> >> What

Re: [GENERAL] Problems with timestamp with time zone and old dates?

2012-08-21 Thread Scott Marlowe
On Tue, Aug 21, 2012 at 10:08 PM, Scott Marlowe wrote: > On Tue, Aug 21, 2012 at 3:29 PM, Michael Clark 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

Re: [GENERAL] Problems with timestamp with time zone and old dates?

2012-08-21 Thread Scott Marlowe
On Tue, Aug 21, 2012 at 3:29 PM, Michael Clark 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. -- Sent

Re: [GENERAL] Problems with timestamp with time zone and old dates?

2012-08-21 Thread Michael Clark
Hello. Thanks for the response. The value being returned from PG, with the odd offset is expected? Thanks again, Michael. On Tue, Aug 21, 2012 at 5:50 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > On 08/21/2012 02:29 PM, Michael Clark wrote: > >> Hello all, >> >> I have a weir

Re: [GENERAL] Problems with timestamp with time zone and old dates?

2012-08-21 Thread Steve Crawford
On 08/21/2012 02:29 PM, Michael Clark wrote: Hello all, I have a weird situation I am trying to work through, and could use some help if anyone can provide some. I have a table with a column to store timestamp with time zone, and when I store an older take (before 1895 or so), the value I ge

[GENERAL] Problems with timestamp with time zone and old dates?

2012-08-21 Thread Michael Clark
Hello all, I have a weird situation I am trying to work through, and could use some help if anyone can provide some. I have a table with a column to store timestamp with time zone, and when I store an older take (before 1895 or so), the value I get back from PG when doing a select seems odd and i