sql sever date column sorting dates automatically : I have a table with a date column.
I am inserting dates in that column using DateTimePicker in c#.

Everything works fine. But I want the dates inserted in the table to be ordered. Currently when I add today's date in one row and then add yesterday's date or any past date, it gets added in the 2nd row ofc.
I want that to be added in 1st row instead. Before today's date, to make all the dates in order.

Is there any property of the date column I can use to ensure the dates order?