Michael Fuhr <[EMAIL PROTECTED]> writes:
> Maybe a warning that the specified timezone wouldn't be in effect
> on the given date?
No thanks. It is not wrong for example to refer to EST all year round.
regards, tom lane
---(end of broadcast)---
On Sun, Oct 17, 2004 at 04:45:45PM +0700, David Garamond wrote:
> When a timestamp string input contains a timezone abbreviation (CDT,
> PST, etc), which timezone offset is used? The input date's or today
> date's? The result on my computer suggests the latter.
>
> # create table ts (ts timestam
When a timestamp string input contains a timezone abbreviation (CDT,
PST, etc), which timezone offset is used? The input date's or today
date's? The result on my computer suggests the latter.
# create table ts (ts timestamptz);
# insert into ts values ('2004-10-17 00:00:00 CDT'); -- UTC-5
# inse
