Re: casting timeofday() to timestamp boken under cygwin - Problem identified

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tim McAuley <mcauleyt(at)tcd(dot)ie>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: casting timeofday() to timestamp boken under cygwin - Problem identified
Date: 2003-08-01 14:41:22
Message-ID: 7933.1059748882@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

Tim McAuley <mcauleyt(at)tcd(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-08-01 14:55:49 Re: extract and time zones
Previous Message Oscar Estevez Lopez 2003-08-01 11:39:59 extract and time zones

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2003-08-01 14:43:23 Re: PC color icon data?
Previous Message Shridhar Daithankar 2003-08-01 14:33:28 Re: Table Stats