Re: Timestamp/Timezone - does this make sense? - Mailing list pgsql-general

Ron Johnson <ron.l.johnson@cox.net> 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