Re: 'NOW' in UTC with no timezone

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