MySQL timestamp to date
Posted: Wed Mar 29, 2006 12:25 am
Hai all.
I look in my MySQL and i hav INSERT relly mouch data ind then and now i whot to convert timestamp to date ( yyyy-mm-dd ) soe i can get this comment to work
and tell my about ist right function to 
thx for all help
I look in my MySQL and i hav INSERT relly mouch data ind then and now i whot to convert timestamp to date ( yyyy-mm-dd ) soe i can get this comment to work
Code: Select all
$GetBrowser = mysql_query("SELECT countrynick, DATE(runtime), COUNT(DISTINCT ipaddress) AS Count FROM besog_log WHERE kundeid = '$UserID' GROUP BY countrynick, DATE(runtime) ORDER BY Count DESC");thx for all help