> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 22 May 2007 15:47
> To: mysql@lists.mysql.com
> Subject: a function to convert a uk date to and from mysql date
>
>
> Hi,
>
> My UK dates are this format DD/MM/ I want it reversed and
> then the seperator
My UK dates are this format DD/MM/ I want
it reversed and then the seperator changed so it becomes
-MM-DD
I use this PHP at the moment
$available_from = implode('/', array_reverse(explode('-',
$available_from)));
An even better solution would be:
$UKDate = '22/05/2007'
$USDate = date(