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 Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.