[RESOLVED] Order Results by date & time of insert

[Megahertza]

I want to order the results from a query for date and time. The table doesn't have a date or time field. Does Mysql note the time and date a insert has been made and can i use that. IF not, do you have any suggestion that I can do. Thanks guys

[jheitz]

I don't believe MySQL will hold that info. My suggestion is that you create a DateCreated field in every table and have it had a default value of the current date. Not sure how to do this in MySQL but it certainly is possible, in SQL Server it is something like:

ALTER TABLE XYZ ADD DateCreated DEFAULT getdate();

Then you no longer have the problem of not having a date 😉