Get timestamp as UTC

From: "Steve - DND" <postgres(at)digitalnothing(dot)com>
To: "postgres-general" <pgsql-general(at)postgresql(dot)org>
Subject: Get timestamp as UTC
Date: 2005-04-21 17:51:05
Message-ID: LDEHKBBOEMIJKHKBOFNFMEEJNGAA.postgres@digitalnothing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was under the impression that using timezone('UTC', now())::timestamptz
would give me the current UTC time, with timezone offset. Instead I am
getting the UTC time, but with an offset of -07(my local time). How do I get
UTC time, with the 0 offset that it should be?

Thanks,
Steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2005-04-21 17:56:30 Re: List of Functions
Previous Message Joel Leyh 2005-04-21 17:27:48 tsearch2 trigger