MYSQL - Order timestamp values ascending in order, from newest to oldest?

Question

I have come across a problem when trying to order certain results by their timestamp value. I would like these results displayed from the newest, to the oldest based on the timestamp values. So to explain this, imagine that there were 3 results: ``` 2012-07-11 17:34:57 2012-07-11 17:33:28 2012-07-11 17:33:07 ``` This result set would be what I would require, but given the following query ``` SELECT timestamp FROM randomTable ORDER BY timestamp ASC ``` I get: ``` 2012-07-11 17:34:57 2012-07-11 17:33:07 2012-07-11 17:33:28 ``` This is as it is sorted by numerical value and `07` comes before `28`. If i sort in descending order I get ``` 2012-07-11 17:33:07 2012-07-11 17:33:28 2012-07-11 17:34:57 ``` Which is what I am looking for... But it is in reverse. So my question is fairly simple, how could I sort these values in ascending order as I have described? EDIT: EDIT2: ``` CREATE TABLE `user_quotations` ( `id` int(100) NOT NULL AUTO_INCREMENT, `quoteNumber` int(100) NOT NULL, `lastModifie…

Accepted Answer

Your query :

```
SELECT timestamp
FROM randomTable
ORDER BY timestamp ASC;
```

is perfect. But I doubt about the results you have presented in your posting. You posted :

```
2012-07-11 17:34:57
2012-07-11 17:33:07
2012-07-11 17:33:28
```

But results in your sqlbox shows :

```
2012-07-11 17:34:57
2012-07-15 17:33:07
2012-07-15 17:33:28
```

Which are perfectly right.

Is that a typo error in your posting? If no, then try the following :

```
SELECT timestamp( `timestamp` ) as 'timestamp'
FROM randomTable
ORDER BY 1 ASC;
```

MYSQL - Order timestamp values ascending in order, from newest to oldest?

Solution

Problem