Re: RES: [SQL] Datetime problem

2004-06-14 Thread Tom Lane
"Alexander M. Pravking" <[EMAIL PROTECTED]> writes: > Hmm, 7.3 and 7.4 docs say that it returns timestamp (WITHOUT time zone > is default since 7.3 IIRC), but in fact it accepts and returns timestamp > WITH time zone. This is probably a documentation bug... Yeah, it is. Fixed in CVS tip --- thank

Re: RES: [SQL] Datetime problem

2004-06-14 Thread Tom Lane
"Eric Lemes" <[EMAIL PROTECTED]> writes: > - PostgreSQL 7.3.2 on i386-redhat-linux GCC 3.2.2 > - Timezone: Brazil (GMT-3, I think). Ah, and 2004-10-10 is a daylight savings transition day where you live, right? (Or at least the obsolete timezone file you have thinks so...) So local midnight on th

Re: RES: [SQL] Datetime problem

2004-06-14 Thread Alexander M. Pravking
On Mon, Jun 14, 2004 at 01:20:14PM -0300, Eric Lemes wrote: > Hello, > > - PostgreSQL 7.3.2 on i386-redhat-linux GCC 3.2.2 > - Timezone: Brazil (GMT-3, I think). What's about daylight saving time for you? I'm almost sure the DST boundary is near the date in your example. However, with 7.3.4 on F