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

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.

Please go read the docs at the links I supplied.

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?

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.

Please submit that patch then so we can include it.

Derick

--- 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);
+	}
+
 	;

the above patch was generated against php-4.2.1

Assigned to Derick. He mumbled something about rewrite..

Finally fixed in CVS (PHP 5). The patch included didn't work at all anymore, so I came up with my own version. I might merge this to PHP 4.3.4, but after PHP 4.3.3 has been released.

Derick