RE: a function to convert a uk date to and from mysql date

2007-05-22 Thread Edward Kay
> -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

Re: a function to convert a uk date to and from mysql date

2007-05-22 Thread Chris Boget
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(