My DateTime field is driving me crazy!!

[xces]

I have this SQL:

SELECT roosterid, begin, eind, positie FROM ROOSTER, POSITIE WHERE ROOSTER.positieid=POSITIE.positieid AND ROOSTER.crewid=3 AND ROOSTER.begin>='2003-02-01' AND ROOSTER.eind<='2003-04-01' ORDER BY ROOSTER.begin ASC;

Whenever i use this php function on the field "begin"
$row=mysql_fetch_array($result);
$arrID = date("Y-m-d", $row['begin']);

i get this back:
1970-01-01

AAAAAAAARGH!!!!!!!

Can anybody help me?

[nnichols]

The most likely problem is that you are passing a date instead of a unix timestamp to the date() function. If this is not the case it probably means that your timestamp is out of the range for the date() function - pre January 1 1970.

[website]

Well, if the field is datetime, instead of using the php function date() use in the query DATE_FORMAT(column, '%Y-%m-%d') AS something
then you simply do $row['something'] and it is there, see mysql manual here and see the section where there is a big table with all the %Y .... possibilities.