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
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
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 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
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
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
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
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
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