timestamp ascending order vs descending order sql code example

Example 1: 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

Example 2: sql order by timestamp

SELECT timestamp
FROM randomTable
ORDER BY timestamp ASC;