Re: [BUGS] [GENERAL] Convert TimeStamp to Date

2003-07-23 Thread Tom Lane
Dmitry Tkach <[EMAIL PROTECTED]> writes: > In 7.3 (and 7.4) timestamptz_date () is still doing that (and select > '1999-12-31 00:00:01'::timestamptz::date still works), > *but* timestamp_date() is changed for some reason to just divide the > timestamp by the number of microseconds per day, that i

Re: [BUGS] [GENERAL] Convert TimeStamp to Date

2003-07-23 Thread Dmitry Tkach
Yep ... looks like it got broken in 7.3. 7.2.4 works fine, but 7.3 (and CVS tip) doesn't. This is because in 7.2, timestamp_date () and timestamptz_date () do the same thing - convert the time to Julian date and then subtruct the offset for Y2K, and both work. In 7.3 (and 7.4) timestamptz_date (