to all guru:
how can i convert my date_time format to UNIX Time ? eg : My date : 2004-10-14 12:10:16
[man]strtotime[/man] although it may not always work as expected so id try using mktime if that is the format for all use.
breaking up your date using functions such as substr(), explode() then after getting each of the date and time element separated, use mktime().
$getdate=strftime("%Y/%m/%d",strtotime($result->joindate)); $dateexplode=explode("/",$getdate); $newvalue=mktime(0,0,0,$dateexplode[1],$dateexplode[2],$dateexplode[0]);
got the right result