dbTalk Databases Forums  

[BUGS] casting timeofday() to timestamp boken under cygwin - Problem identified

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] casting timeofday() to timestamp boken under cygwin - Problem identified in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tim McAuley
 
Posts: n/a

Default [BUGS] casting timeofday() to timestamp boken under cygwin - Problem identified - 08-01-2003 , 06:17 AM






Hi there,

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.

See the following code segments:

mcauleyt=# select timeofday();
timeofday
---------------------------------------
Fri Jul 25 10:38:13.056614 2003 GMTST
(1 row)

mcauleyt=# select substr(timeofday(), 1, 35);
substr
-------------------------------------
Fri Jul 25 10:38:16.952614 2003 GMT
(1 row)

mcauleyt=# select timeofday()::timestamp;
ERROR: Bad timestamp external representation 'Fri Jul 25
10:38:51.410614 2003 GMTST'

mcauleyt=# select substr(timeofday(), 1, 35)::timestamp;
substr
----------------------------
2003-07-25 10:38:57.918614
(1 row)


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] casting timeofday() to timestamp boken under cygwin - Problem identified - 08-01-2003 , 09:42 AM






Tim McAuley <mcauleyt (AT) tcd (DOT) ie> writes:
Quote:
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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.