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

[Steve - DND]

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



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster