casting timeofday to timestamp broken under cygwin

From: Tim McAuley <mcauleyt(at)tcd(dot)ie>
To: pgsql-bugs(at)postgresql(dot)org
Subject: casting timeofday to timestamp broken under cygwin
Date: 2003-07-25 10:20:08
Message-ID: 3F210458.6020201@tcd.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tim McAuley 2003-07-25 10:44:53 casting timeofday() to timestamp boken under cygwin - Problem identified
Previous Message Bruce Momjian 2003-07-24 22:12:48 Re: When "psql -l" is invoked from prompt and not completed,