Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
06-27-2002, 09:59 AM #1
- Join Date
- Jun 2002
- Thanked 0 Times in 0 Posts
How to order by date inselect statement using Microsoft SQL query
I would like to do a SELECT query statement from a table and would like to order the records based on date field in the table.
How can I do it using Microsoft SQL?
Select * from MMPODT order by keyval3(date's field name)
The date field's data type is character and it is displayed as 20020625 (yyyymmdd)