Order By with DateTime column
Posted By: ASPEvil Posted Date: November 11, 2010
Points:2 Category :Sql Server
I have a column with the datatype "DateTime" and I want to use "Order By" with this column for date and time, means it will first order the data by date then by time. So, if there are data with the same date but different time, will be shown properly.
I have written the query, but it is not at all working for the time, means if there are data with same date but different time, then "order by" clause is not working to sort data by time.
Please let me know, how to accomplish this job.
You must Sign In To post reply