Stuart Bishop <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster