help in preg match

[angela_john]

hi i have a old data formate 1/5/2009 i have to change this in YYYY-MM-DD

 

please help me to do this in preg match

 

thanks

[mikecampbell]

Use explode:

 

list($month, $day, $year) = explode('/', '1/5/2009');

 

You may have to pad your month and day with a zero...

 

if (strlen($day)==1) $day = '0'.$day;
if (strlen($month)==1) $month = '0'.$month;
echo "$year-$month-$day";

[.josh]

If your example date is m/d/y format (as in, January 5th, 2009) then you can do this:

 

$newDate = date('Y-m-d',strtotime($oldDate));

 

 

 

[angela_john]

sir i have a sql.txt file and i am reading that file using php and want to find this date and replace with my MySQL database formate thats why i need preg match can some one help me

[anandgodar]

Before moving to the regular expression i will suggest you to first read all the meanings of metacharacter in regular expression

 

 

[sasa]

try to use mysql function STR_TO_DATE()

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_str-to-date