Date trouble

[Anon]

I'm having trouble with the date format.
The server that hosts the webpage displays
the date like this mm/dd/yyyy.

The date is entered dd/mm/yyyy.

Can I use SQL to convert it?

Thanks in advance.
Sverrir

[Anon]

Try this.

$date_pieces = split("/", $input_date);
$formatted_date = $input_date[1]."/".$input_date[0]."/".$input_date[2];

This is the best solution I have for your problem.

Hope that helps!

Chris King

[Anon]

Want use sql to convert dates?
If you use mysql, there are a lot of good functions to handle dates.
For your question, you could use date_format function.
In your particular case, try this:

select date_format('2001-12-31', '%d %c %Y') as my_format_date;

P.S.
I suppose that the date in the database is stored in the form YYYY-MM-DD.