Forum Moderators: coopster & phranque

Message Too Old, No Replies

Converting Dates

         

ramoneguru

4:22 am on Apr 22, 2005 (gmt 0)

10+ Year Member



I am retrieving a date from mysql (using the mysql date format YYYY-MM-DD format). Is there an easy way to convert a date in that format:
YYYY-MM-DD
to this format:
MM-DD-YYYY

I've seen a few online, but they all involve ridiculous regular expressions....
--Nick

ramoneguru

4:24 am on Apr 22, 2005 (gmt 0)

10+ Year Member



Sorry I meant to post this in the PHP section
--Nick

rocknbil

3:25 pm on Apr 22, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



($y,$m,$d) = split(/\-/,$inDate);
$newdate = qq¦$m-$d-$y¦;

Or just restore it in the old variable

$inDate = qq¦$m-$d-$y¦;

ramoneguru

11:08 pm on Apr 22, 2005 (gmt 0)

10+ Year Member



Cool, Thanks.
--Nick