Posted by "Rosty Kerei" on 12/27/05 18:45

You should better store your dates in unix timestamp, integer format and
then display it on your web site with using date(), or smarty date_format
function in any format you wish.

Sincerely,
Rosty Kerei <rosty.kerei@gmail.com>


""William Stokes"" <kalles@operamail.com> wrote in message
news:66.02.28258.F3941B34@pb1.pair.com...
> 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

[Back to original message]