esql.org
Subject: Re: [GENERAL] YTA Time Zone Question
On Thu, Apr 05, 2007 at 05:52:02PM -0700, Danny Armstrong wrote:
> If ruby and python tell me the value I just inserted into the db,
> 1174773136, is Sat Mar 24 21:52:16 UTC 2007, then I expect that
>
> set time zone 0; -- form
On Thu, Apr 05, 2007 at 05:52:02PM -0700, Danny Armstrong wrote:
> If ruby and python tell me the value I just inserted into the db,
> 1174773136, is Sat Mar 24 21:52:16 UTC 2007, then I expect that
>
> set time zone 0; -- format as though I'm in utc
> select measurement_time
> from table
>
> wil
Danny Armstrong <[EMAIL PROTECTED]> writes:
> What am I misunderstanding and how do I get it to interpret the value as
> utc and then not offset it when I view it, like python and ruby do?
What you're misunderstanding is that you messed up the data when you put
it into the database, probably by ha
Hi,
I have a question regarding postgres 8.2 handling of timezones.
I receive posts of unix timestamps and convert them and save them to a
timestamptz(0). I've read the docs on this, timestamptz stores
internally as utc. The date is formatted per local time on display.
If ruby and python tell me
