From: "Angelo Zanetti" <[EMAIL PROTECTED]>
> This might be slightly off topic but hopefully someone can help.
> I have a field that is a varchar and I stored dates in it. But now I want
> change the type of the column to date, but I have a problem that the
> my format: mm/dd/yyyy
> mySQL format: yyyy-mm-dd
> So can I either:
> a. change the format of the date format
> b. do i have to write a function that changes my format to the mySQL
> changing the column type??
You need to do option (b). Since this is a PHP list, I'd recommend
strtotime() and date() to do the formatting.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php