denoteone Posted January 29, 2010 Share Posted January 29, 2010 I am importing articles into a database for a client. I am sure they will want to sort them by newest to oldest. If I have a column that uses a time stamp can I use that column later to DESC? Does anyone recommend a away to enter the data and be able to sort by date? Thanks Everyone for your Help and thoughts Link to comment https://forums.phpfreaks.com/topic/190237-planning-ahead-to-sort-by-date/ Share on other sites More sharing options...
PFMaBiSmAd Posted January 29, 2010 Share Posted January 29, 2010 Which kind of a timestamp? There is a Unix timestamp and there is a mysql TIMESTAMP (which is actually a Unix timestamp but is input/output as a '1970-01-01 00:00:01' format.) You should normally use a mysql DATETIME data type to avoid all the problems, limitations, and extra time and code needed when a Unix timestamp is used. Link to comment https://forums.phpfreaks.com/topic/190237-planning-ahead-to-sort-by-date/#findComment-1003698 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.