Date & Database

[fean0r]

Hi just a quick 1

I current use date format 13/07/2006 (dd/mm/yyyy) now I was to list items from a database showing the earliest date first.

Has anyone got any suggestions as to the best way to do this?

[Stasonis]

Is the date stored in the database as a string? That makes things a little complicated, but not impossible. You could select the date like this:

SELECT

CONCAT(SUBSTRING("13/07/2006", 7, 4),
	SUBSTRING("13/07/2006", 1, 2),
	SUBSTRING("13/07/2006", 4, 2)) AS 'new_date'

and ORDER BY 'new_date'

[fean0r]

Cheers I will try that.

I would be happy to convert the date before storing then run the query and convert the date back through php if its easier?