I want to show records from a table having a date column from sqldatabase in dates order. How should I?

Question

I want to show records from a table having a date column from sqldatabase in dates order. How should I?

Answer 1

SELECT
    *
    FROM yourTable
    ORDER BY yourDateColumn

Answer 2

SELECT * FROM `table_name` ORDER BY `dates_column`

optionally you can add DESC to reverse the order (newest to oldest):

SELECT * FROM `table_name` ORDER BY `dates_column` DESC

Answer 3

If I understand your question correctly, you want to use an ORDER BY clause on the column containing the dates.

Answer 4

you can use order by

select * from my_table t order by t.date_column

where date_column is a column name in your table.

Answer 5

The database engine should handle the proper sorting for a date or timestamp column using an ORDER BY clause. The only exception might be if your column is of type VARCHAR and holds a date of the form "mm/dd/yyyy". Then you've got a bit more work to do.