Re: date problem in MySQL DB
| From: | CPT John W. Holmes | Date: | Tue, 13 Jan 2004 11:54:39 +0000 |
| Subject: | Re: date problem in MySQL DB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32368@lists.php.net to get a copy of this message | ||
From: "Angelo Zanetti" <binc2@ctech.ac.za>
> 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
to
> change the type of the column to date, but I have a problem that the
formats
> 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
before
> 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...