Bug #17988 Updated: strtotime fails to parse timestamp type from postgresql

ID: 17988 Updated by: sniper@php.net Reported By: jam@newimage.com -Status: Open +Status: Assigned Bug Type: Feature/Change Request Operating System: redhat 7.3 PHP Version: 4.1.2 -Assigned To: +Assigned To: derick New Comment: Assigned to Derick. He mumbled something about rewrite.. Previous Comments: ------------------------------------------------------------------------ [2002-06-27 15:08:22] jam@newimage.com the above patch was generated against php-4.2.1 ------------------------------------------------------------------------ [2002-06-27 14:52:15] jam@newimage.com --- parsedate.y.old Thu Jun 27 14:26:11 2002 +++ parsedate.y Thu Jun 27 14:43:28 2002 @@ -262,4 +262,13 @@ } } + | tUNUMBER ':' tUNUMBER ':' tUNUMBER '.' tUNUMBER tSNUMBER { + yyHour = $1; + yyMinutes = $3; + yySeconds = $5; + yyMeridian = MER24; + yyDSTmode = DSToff; + yyTimezone = - ($8 % 100 + ($8 / 100) * 60); + } + ; ------------------------------------------------------------------------ [2002-06-26 01:26:46] derick@php.net Please submit that patch then so we can include it. Derick ------------------------------------------------------------------------ [2002-06-26 01:05:23] jam@newimage.com ok. while I believe parsedate.y needs to be updated to handle floating point seconds values (I've done it, it's not hard to patch), I *do* see the value of the documentation you pointed out, and I think I can get the code to work. thank you for your help. ------------------------------------------------------------------------ [2002-06-26 00:58:40] jam@newimage.com I have read the docs :) maybe I've missed something (happens all the time).. could you suggest a way to do what I want without using strtotime()? I'm missing something.. is there a way to extract the entire date/time string with postgresql functions? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/17988 -- Edit this bug report at http://bugs.php.net/?id=17988&edit=1