<p>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?</p> <h3>EDIT:</h3> <p>Thanks everyone for replying. I understand now. I will make <strong>Sarfraz</strong> 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.</p>

<p>You should perform a SQL Query like below</p> <pre class="prettyprint"><code>SELECT * FROM News ORDER BY date DESC </code></pre>

ORDER By Unix Timestamp DESC or ASC?

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.

207

asked Feb 16 '11 19:02

PHPLOVER

2 Answers

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

119

answered Oct 23 '22 06:10

Marc B

You should perform a SQL Query like below

SELECT * FROM News ORDER BY date DESC

answered Oct 23 '22 06:10

dextervip

Related questions
                            
                                Group by LIKE of a column value
                            
                                How to have the semicolon character in a password for a SQL connection string?
                            
                                SQL Batched Delete
                            
                                Inserting column between other columns in SQL Server using script [duplicate]
                            
                                create foreign key without a primary key
                            
                                Deleting rows in a table with Linq to SQL
                            
                                Compare field with value and return bool
                            
                                Writing a function to select data only on weekdays in PostgreSQL
                            
                                MySql count() to return 0 if no records found
                            
                                replace NULL with Blank value or Zero in sql server
                            
                                How to count number of records in an SQL database with python
                            
                                Use OR Clause in queryover in NHibernate
                            
                                Case statement for Order By clause with Desc/Asc sort
                            
                                Correct way to use LIKE '%{$var}%' with prepared statements? [mysqli]
                            
                                'CREATE PROCEDURE' must be the only statement in the batch (Erro) [duplicate]
                            
                                Listing all sequences in a SQL Server database
                            
                                How do I get the position of a result in the list after an order_by?
                            
                                Guid Primary /Foreign Key dilemma SQL Server
                            
                                SQL Server Linked Database Aliases
                            
                                MySQL how to do an if exist increment in a single query

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With

ORDER By Unix Timestamp DESC or ASC?

Tags:

sql

mysql

sql-order-by

unix-timestamp