Hi there all PostgreSQL Hackers.
We have just upgraded from 7.1.3 to 7.2.3 over the weekend, and have just
noticed something weird with regards 'epoch'::timestamp.
In 7.1.3, 'epoch'::timestamp always returned the value 1970-01-01
00:00:00+00, following the upgrade we now get:-
timestamptz
23:00:00+00
(2 rows)
I think that the best way forward for us (short of re-writing the backend to
use NULL) will be to just alter the default value to the one in column b in
the test table above.
With regards the disclaimer, don't you just love lawyers ;-)
Once again, thanks for replying
To: Hosen, John
Cc: 'Thomas Lockhart'; '[EMAIL PROTECTED]'
Subject: Re: [HACKERS] 'epoch'::timestamp and Daylight Savings
"Hosen, John" <[EMAIL PROTECTED]> writes:
> e_app_print_date | timestamp with time zone | default
> "timestamp"(
