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 sending
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 I select:
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
--
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
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 weird
On Tue, Aug 21, 2012 at 3:29 PM, Michael Clark codingni...@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
On Tue, Aug 21, 2012 at 10:08 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Aug 21, 2012 at 3:29 PM, Michael Clark codingni...@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
On Tue, Aug 21, 2012 at 10:12 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Aug 21, 2012 at 10:08 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Tue, Aug 21, 2012 at 3:29 PM, Michael Clark codingni...@gmail.com wrote:
For example, if I insert like so:
INSERT INTO sometable
