Postgres Pro
Downloads
Home   >   mailing lists

Get timestamp as UTC - Mailing list pgsql-general

From Steve - DND
Subject Get timestamp as UTC
Date
Msg-id LDEHKBBOEMIJKHKBOFNFMEEJNGAA.postgres@digitalnothing.com
Whole thread Raw
Responses Re: Get timestamp as UTC  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Joel Leyh
Date:
Subject: tsearch2 trigger
Next
From: Oleg Bartunov
Date:
Subject: Re: List of Functions