CODEWITHSUNDEEP
mysqltimestamp
Darksody
Darksody

Reputation: 539

MySQL order by timestamp, don't have the field

I have a MySQL table with the field "date". I am trying to order the entries by date, and if more entries are from the same day, then i need to order them by a timestamp. The problem is my "date" field only stores the day, and i do not have a timestamp field and i don't want to add it, since the table is already populated with a few thousands of entries.

Is it possible to order them by a timestamp, i don't know, maybe from sql dictionary or something?

Thank you.

Upvotes: 0

Views: 99

Answers (2)

Darksody
Darksody

Reputation: 539

Solved by added a new column..

Upvotes: 0

Ross Smith II
Ross Smith II

Reputation: 12189

Is it possible to order them by a timestamp, i don't know, maybe from sql dictionary or something?

No, it's not possible. You can't sort by something that doesn't exist.

Upvotes: 1

Related Questions