Webmaster2020.com

Posted: **Wed Sep 26, 2012 1:52 pm**

Hi,

i would like to convert a text date like "2012 July 11 16:00"
To a SQL conform date. (JJJJ-MM-DD)

I tried it with

date('Y-m-d', strtotime('2012 July 11 16:00');

But always gives me 1970-01-01.

Posted: **Wed Sep 26, 2012 7:34 pm**

strtotime() does its job well, but it need to be in the correct order.
day month year

Use a function to switch the dates:

Code: Select all

function switch_date($str)
{
  //split string
  $arr=explode(' ',$str);
  //put in correct order
  $new_str=$arr[2].$arr[1].$arr[0].$arr[3];
  return  date('Y-m-d', strtotime($new_str));
}

Webmaster2020.com

php convert text date

php convert text date

Re: php convert text date