Converting US date format to UK

[Matt_Parsons]

I have a table in mysql where one of the columns is date with data type date.
The problem with this is when i input a UK date to it, it gets messed up, as Mysql only want to accept US date format.

Similiarly if i store a date in us format, how can i then convert it back to UK format.

I really need to be able to sort the table by UK date. Can anyone suggest some ideas.

[Traduim]

Once you have the dates well entered in your MySQL database, you can always sort a SELECT using ORDER BY Year(date) [ASC|DESC], Month(date) [ASC|DESC]

To change the format of dates, check [man]date()[/man] in the functions reference.

You may also want to take a look at [man]set_locale()[/man]. (Or was it [man]setlocale()[/man]?)