RE: [PHP] Varchar "date" to real date?
| From: | Jim Moseby | Date: | Tue, 27 Dec 2005 15:22:53 +0000 |
| Subject: | RE: [PHP] Varchar "date" to real date? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-227889@lists.php.net to get a copy of this message | ||
> > 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?
I neglected to answer the second part of your question. Once you get the
dates into a proper mysql date column, you can use mysql's DATE_FORMAT
function to arrange it to any way you want.
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
JM