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
> differ:
> my format: mm/dd/yyyy
> mySQL format: yyyy-mm-dd
> So can I either:
> a. change the format of the date format
> or
> 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.

---John Holmes...

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to