Postgres Pro
Downloads
Home   >   mailing lists

Re: casting timeofday() to timestamp boken under cygwin - Problem identified - Mailing list pgsql-bugs

From Tom Lane
Subject Re: casting timeofday() to timestamp boken under cygwin - Problem identified
Date
Msg-id 7933.1059748882@sss.pgh.pa.us
Whole thread Raw
In response to casting timeofday() to timestamp boken under cygwin - Problem identified  (Tim McAuley <mcauleyt@tcd.ie>)
List pgsql-bugs
Tree view 
Tim McAuley <mcauleyt@tcd.ie> writes:
> Regarding my last email. I have found the issue. Windows 2K is reporting
> the timezine as GMTDT (GMT, Dublin time... I think) and I don't believe
> Postgresql can understand this.

No, it wouldn't recognize that.  You could add the zone name as a
keyword in the datetktbl[] table, src/backend/utils/adt/datetime.c.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tim McAuley
Date:
Subject: casting timeofday to timestamp broken under cygwin
Next
From: "arulbhavani"
Date:
Subject: [sap-portals-admins] Re: SSO to Non-SAP Systems using SAP Login Tickets