[thelist] select

Anthony Baratta Anthony at Baratta.com
Tue Jan 9 19:38:30 CST 2001


At 03:38 PM 1/9/2001 -0800, you wrote:
>is there to get the results of a sql query to sort by actual date instead
>of numbered date?  for instance, right now it will give:


Are you using a Date Field or a text field (char/varchar/nvarchar)?

If you use a date field, it will sort correctly.

If you are using a text field, you might want to try:

SELECT Field1 FROM Table1
Order By Year(Field1), Month(Field1), Day(Field1)

---
Anthony Baratta
President
Keyboard Jockeys





More information about the thelist mailing list