help with php DATE problem

zoya23

Does anyone know how to get only the date element from the datetime value?

For example: I want to get only 2005-01-23 from 2005-01-23 10:00:00.

This is how I try to do it, but did not work:

$gamerecord = mysql_query ("Select username,gameid, DATE(cust_readingdate),cust_readingpoint from cust_reading where username = 'do' and gameid = '10' ");

Thanks
zoya

Shrike

DATE_FORMAT()

zoya23

I have used the DATE format but did not work.

This is what i use:
$gamerecord = mysql_query ("Select DATE(cust_readingdate)from cust_reading ");

Is there any other solution?

Thanks

Shrike

Yes, use the DATE_FORMAT() function rather than just DATE().

zoya23

I have use the date_format() and this is the error that I have got:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/tarot/index.php on line 291

kburger

or you could just split() your date like:

list ($dateyouwanttouse, $junk) = split(" ", $datereturnedbyquery);

zoya23

A bit confusing.

Could you please explain more on how to put them onto the select statement?

Roger_Ramjet

Version specific: so the first question is what version of mysql are you using?

cezve

DATE_FORMAT(date, '%d-%m-%Y')

SELECT DATE_FORMAT(datetime_column_name, '%d-%m-%Y') from table_name