Web Analytics Made Easy -
StatCounter How to order by date inselect statement using Microsoft SQL query - CodingForum

Announcement

Collapse
No announcement yet.

How to order by date inselect statement using Microsoft SQL query

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to order by date inselect statement using Microsoft SQL query

    Hi,

    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?

    For example:

    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)
Working...
X