convert date string to mysql datetime field

Posted by mjr on Stack Overflow See other posts from Stack Overflow or by mjr
Published on 2010-03-23T16:57:04Z Indexed on 2010/03/23 17:03 UTC
Read the original article Hit count: 251

Filed under:
|

I have a bunch of records with dates formatted as a string such as '04/17/2009'

I want to convert them to a mysql datetime field

I plan to use a foreach loop to read the old date value and insert the newly formatted value into a new field in each record

what would be the best way to convert that string...I thought php might have a way to do it automatically?

thanks

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql