casting timeofday to timestamp broken under cygwin
От | Tim McAuley |
---|---|
Тема | casting timeofday to timestamp broken under cygwin |
Дата | |
Msg-id | 3F210458.6020201@tcd.ie обсуждение исходный текст |
Список | pgsql-bugs |
Hi, I am unable to cast the output of timeofday() to a timestamp under postgresql 7.3.3-1 under cygwin. I can do so under 7.3.2 running on Linux. All the best, Tim Results as follows: ________________________________________________________________________________ Cygwin - Postgresql 7.3.3 - Windows 2000: ________________________________________________________________________________ version ----------------------------------------------------------------------------------------- PostgreSQL 7.3.3 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (prerelease) # select timeofday(); timeofday --------------------------------------- Fri Jul 25 11:14:50.406227 2003 GMTDT # select timeofday()::timestamp; ERROR: Bad timestamp external representation 'Fri Jul 25 11:15:23.629227 2003 GMTDT' ________________________________________________________________________________ Redhat Linux 9, Postgresql 7.3.2 ________________________________________________________________________________ version ----------------------------------------------------------------------------------------------------------------------------------- PostgreSQL 7.3.2 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.2.2 20030213 (Red Hat Linux 8.0 3.2.2-1) # select timeofday(); timeofday ------------------------------------- Fri Jul 25 11:05:23.371428 2003 IST # select timeofday()::timestamp; timeofday ---------------------------- 2003-07-25 11:05:45.440165
В списке pgsql-bugs по дате отправления: