Re: timezone() with timeofday() converts the wrong direction?

From: "Steve - DND" <postgres(at)digitalnothing(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: "postgres-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: timezone() with timeofday() converts the wrong direction?
Date: 2005-04-21 23:11:57
Message-ID: LDEHKBBOEMIJKHKBOFNFEEGONGAA.postgres@digitalnothing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> Perhaps this is what you want:
>
> SELECT timezone('UTC', timeofday()::timestamptz);

That did it. Strangely, I thought I had tried that already, but I must not
have. My next question would be if I did:

SELECT timezone('UTC', timeofday()::timestamptz):timestamptz;

Why do I get the timezone value as being -07(my local offset), instead
of -00?

Thanks,
Steve

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Miller 2005-04-21 23:27:08 Install development headers/libraries Win32 v 8.0.2
Previous Message Michael Fuhr 2005-04-21 23:01:02 Re: timezone() with timeofday() converts the wrong direction?