Update Date Fields

[faheem786]

Hi there,

Since I'm new to PHP, this is the first time I deal with dates.

I need to update date from a tab file into mysql.

There is a date field in the tab file with the value "6/22/1957" (mm/dd/yyyy).

When I update the date field with such a string it's not storing correctly. Instead it stores like 0000-00-00.

I feel like if there might be a function to retrive the year, month and day from a string then I can build like

$MyDate = Year ($MyDate ) . "-". Month($MyDate). "-" . Day($MyDate)

and then update this into the table. But donno how

Any help plsssss

Thanks
Ahmad
Hong Kong

[YappyDog]

You should probably use the strtotime() function to convert your date from mm/dd/yyyy format into a UNIX timestamp. From there you can use the date() function to format it into a yyyy-mm-dd format that will work in your update statement.

http://us4.php.net/manual/en/function.strtotime.php

http://us4.php.net/manual/en/function.date.php