Re: 'NOW' in UTC with no timezone - Mailing list pgsql-general

From Tom Lane
Subject Re: 'NOW' in UTC with no timezone
Date
Msg-id 28230.1097558497@sss.pgh.pa.us
Whole thread Raw
In response to 'NOW' in UTC with no timezone  (Stuart Bishop <stuart@stuartbishop.net>)
Responses Re: 'NOW' in UTC with no timezone  (Greg Stark <gsstark@mit.edu>)
Re: 'NOW' in UTC with no timezone  (Stuart Bishop <stuart@stuartbishop.net>)
List pgsql-general
Stuart Bishop <stuart@stuartbishop.net> writes:
> I'm trying to determine the best way of saying 'The current time in UTC
> with no time zone information'.

Isn't that a contradiction in terms?

I *think* maybe what you want is to SET TIMEZONE = 'UTC' and then
stop worrying about it.  But anyone who is worried about timezones
and yet is storing his data in timestamp-without-time-zone columns
probably needs to reconsider exactly what his data represents.
What is it that you actually want to store, and how do you want
it presented?

            regards, tom lane

pgsql-general by date:

Previous
From: "Eric D. Nielsen"
Date:
Subject: Need some advice on appropriate PL strategy...
Next
From: Greg Stark
Date:
Subject: Re: Need some advice on appropriate PL strategy...