RE: [PHP] Varchar "date" to real date?
| From: | Jim Moseby | Date: | Tue, 27 Dec 2005 14:35:41 +0000 |
| Subject: | RE: [PHP] Varchar "date" to real date? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-227888@lists.php.net to get a copy of this message | ||
>
> Hello,
>
> This is propably a more of a MySQL question but here we go anyway...
>
> I have a DB that has dates stored in a table. The date field
> type is Varchar
> (don't ask why... :( The dates are stored using european date format
> DD.MM.YYYY. I need somehow convert the dates to the format MySQL uses
> (YYYY-MM-DD) and re-store them to a table which has a real
> date column for
> them.
>
> I think I need some help/ideas with this...
>
> If I can get this done how can I still display the dates in
> european format
> at my web page? Do I have to break the date to pieces and some how
> re-arrange it to the DD.MM.YYYY format or is the some clever
> function for
> this that can automatically do this?
>
> Thanks
> -Will
>
function eurodate_to_mysqldate($date){
$parts=explode('.',$date);
$day=$parts[0];
$month=$parts[1];
$year=$parts[2];
return($year.'-'.$month.'-'.$day);
}
This (untested) function will take the varchar date you described and
convert it to a date that mysql will like.
JM