CODE EXAMPLE FOR SQL

timestamp ascending order vs descending order sql

SELECT timestamp
FROM randomTable
ORDER BY timestamp ASC
>2012-07-11 17:34:57
>2012-07-11 17:33:07
>2012-07-11 17:33:28

SELECT timestamp
FROM randomTable
ORDER BY timestamp DESC
>2012-07-11 17:33:07
>2012-07-11 17:33:28
>2012-07-11 17:34:57