ORDERING UNIX Timestamp DESC or ASC?

Question

I have news that when creating, add the time / date creation time in timestamp unix format to the database. If I wanted to order recently, would I use ASC or DESC in my mysql query?

EDIT:

Thanks everyone for the answer. Now I got it. I will make Sarfraz the answer to the decision, as he was the first to answer, but thanks to everyone else :). I have to wait 11 minutes before I can take it as a decision.

Answer 1

DESC - timestamps - this is the number "higher = new". Therefore, sorting by DESC (ending) will first contain the highest (newest) entries.

Answer 2

If I wanted to order the latter first, would I use ASC or DESC in my mysql query?

You order DESC for the latest information or a higher date.

Answer 3

Unix timestamp is the number of seconds since the era (December 1969). Thus, new messages have a larger number, thus sort DESC .

Answer 4

You must execute the SQL query as shown below

 SELECT * FROM News ORDER BY date DESC 

Answer 5

DESC will deliver the largest first to be the last.