ORDER By Unix Timestamp DESC or ASC?

Question

I have news items that when created adds the time of creation date/time in unix timestamp format into the database. If i wanted to order by most recent first would i use ASC or DESC in my mysql query?

EDIT:

Thanks everyone for replying. I understand now. I will make Sarfraz answer the accepted solution as he was first to reply but thanks to everyone else to :) . Have to wait 11 minutes before i can accept it as a solution.

@Col. Shrapnel - I have not fully finished it yet and wanted to make sure before i went any further. — PHPLOVER, Feb 16 '11 at 19:47
oh. just one word made you such a trouble. I wish you luck. Seems you'll need a lot. — Your Common Sense, Feb 16 '11 at 19:53

score 28 · Accepted Answer · answered Feb 16 '11 at 19:40

28

DESC - timestamps are "higher = newer" number. So sorting by DESC(ending) will put the highest (newest) entries first.

answered Feb 16 '11 at 19:40

Marc B

356,200
43
426
500

score 6 · Answer 2 · answered Feb 16 '11 at 19:43

6

You should perform a SQL Query like below

SELECT * FROM News ORDER BY date DESC

answered Feb 16 '11 at 19:43

dextervip

4,999
16
65
93

score 2 · Answer 3 · answered Feb 16 '11 at 19:40

2

If i wanted to order by most recent first would i use ASC or DESC in my mysql query?

You would order by DESC for the most recent info or higher date.

answered Feb 16 '11 at 19:40

Sarfraz

377,238
77
533
578

score 2 · Answer 4 · answered Feb 16 '11 at 19:40

2

Unix timestamp is number of seconds since the epoch (Dec. 1969). So, newer posts have a higher number, thus, sort DESC.

answered Feb 16 '11 at 19:40

Chris Baker

49,926
12
96
115

score 2 · Answer 5 · answered Feb 16 '11 at 19:41

2

DESC will put the largest first, which would be the most recent.

answered Feb 16 '11 at 19:41

jondavidjohn

61,812
21
118
158

ORDER By Unix Timestamp DESC or ASC?

EDIT:

5 Answers5