Ron Johnson <[EMAIL PROTECTED]> writes: > I think he's asking why: > select timestamp with time zone '2007-01-01' > at time zone 'America/Los_Angeles'; > returns a different value than > select timestamp '2007-01-01' > at time zone 'America/Los_Angeles';
Those are transformations in opposite directions; see the manual. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/