conerting date to timestamp

[anujgarg]

I am trying to convert a date string to TimeStamp. Means,

2008-08-20 00:00:00

to

456733800 (say)

 

Should I use strtotime for this? I am not getting the desired result?

 

Please help

[hawkenterprises]

I use this function to do it for me

 

function mysql2timestamp($datetime){

      $val = explode(" ",$datetime);

      $date = explode("-",$val[0]);

      $time = explode(":",$val[1]);

      return mktime($time[0],$time[1],$time[2],$date[1],$date[2],$date[0]);

}

[thebadbad]

strtotime() will do it. What are you getting?

[PFMaBiSmAd]

And since you are likely getting this from a database, just use the mysql UNIX_TIMESTAMP(your_date_column) function in your SELECT query. No need for any slow parsed/tokenized/interpreted php code at all.