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

ID: 17988 Updated by: derick@php.net Reported By: jam@newimage.com Status: Bogus Bug Type: Feature/Change Request Operating System: redhat 7.3 PHP Version: 4.1.2 New Comment: Please submit that patch then so we can include it. Derick Previous Comments: ------------------------------------------------------------------------ [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? ------------------------------------------------------------------------ [2002-06-26 00:52:59] rasmus@php.net Please go read the docs at the links I supplied. ------------------------------------------------------------------------ [2002-06-26 00:50:30] jam@newimage.com I am attempting to extract a timestamp field from the database and convert it to a php time value. the issue is the value that postgresql hands out for the date-- it contains floating point numbers which parsedate.y doesn't know how to handle. ------------------------------------------------------------------------ [2002-06-26 00:48:12] rasmus@php.net There are all sorts of functions in postgresql to format times. http://www.postgresql.org/idocs/index.php?functions-formatting.html http://www.postgresql.org/idocs/index.php?functions-datetime.html ------------------------------------------------------------------------ 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