[Resolved] Order By Date and Time

[D_tunisia]

I have created a submit form which enters a set of data into my SQL database. One of the fields uses...

date("d.m.y, H:i:s",time());

...to enter the date and time into a text field.

The output appears as: 26.02.05, 04:15:26

What I want to do is output this data to a webpage and order the records by date and time, to the second.

The only way I can think to do this is by separating out all of the variables in to separate fields and writing a complex and ugly formula.

Anyone know a better way to do this?

Thanks in advance!

[TheDefender]

Store your date and time into a DATETIME type field instead. You can use the MySQL Date functions to extract the data into whatever format you want, and since it is stored as YYYY-MM-DD HH:MM:SS, you can sort on it using a simple ORDER BY clause in your query.

[D_tunisia]

Originally posted by TheDefender
Store your date and time into a DATETIME type field instead. You can use the MySQL Date functions to extract the data into whatever format you want, and since it is stored as YYYY-MM-DD HH:MM:SS, you can sort on it using a simple ORDER BY clause in your query.

That bloody works! Thanks! 😃

[TheDefender]

You're welcome. Be sure to mark this thread as resolved using the "Mark Thread Resolved" link at the bottom...