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