| From: | Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx> |
|---|---|
| To: | PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | teg(at)redhat(dot)com (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=), brausen(at)yahoo(dot)com |
| Subject: | Redhat 7.3 time manipulation bug |
| Date: | 2002-05-18 04:34:42 |
| Message-ID: | m34rh68465.fsf@dep4.fciencias.unam.mx |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
Something is pretty broken in redhat 7.3 but I'm not sure what and I
don't have time to dig further
masm(at)test=# select cast('1967-04-18' as timestamptz);
timestamptz
------------------------
1967-04-17 18:00:00-06
(1 row)
masm(at)test=# select cast(cast('1967-04-18' as date) as timestamp);
ERROR: Unable to convert date to tm
masm(at)test=#
Both cases works correctly in Redhat 7.2. Sorry if this is not the
correct forum however an alert is nice for people planning an Redhat
upgrade. I hope to see pretty soon an update since I don't want to
downgrade my server.
Regards,
Manuel.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2002-05-18 05:56:23 | Re: Poster(s) needed |
| Previous Message | Barry Lind | 2002-05-18 01:54:32 | Re: Trouble with pg_encoding_to_char |