I have a field in one of my tables called when, which is type timestamp.
I'm trying to use some of the date functions to get data from it, but it's
not working.  The return from mysql_error() is not helpful.  Any ideas?
Here's my query:
$query = mysql_query("select month(when) as month,year(when) as
year,dayofmonth(when) as day,hour(when) as hour,minute(when) as
minute,second(when) as second from table") or print "Error: ".mysql_error(); 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to