Page 1 of 1

date order

Posted: Thu Aug 28, 2003 6:48 pm
by nincha
any tips to reverse a date order in sql? Making the order from newest to oldest.

Posted: Thu Aug 28, 2003 8:01 pm
by McGruff
Add an ORDER BY clause to a SELECT query?

Posted: Fri Aug 29, 2003 5:13 pm
by nincha
i dont understand, right now my query is order by date, but its from oldest to newest, i would like it to be the other way

Posted: Fri Aug 29, 2003 5:21 pm
by greenhorn666
ORDER BY date DESC (instead of the default ASC[ending])

Posted: Fri Aug 29, 2003 6:18 pm
by JAM

Code: Select all

select foo,bar,mydate from table order by mydate desc