Another SQL Question

[mozingod]

OK, I have a Date, and a time field, and I want to display the records w/the most recent at the top. So I'd want to use the ORDER BY w/date DESC and Time DESC... is there a way to do this in one SQL select statement? Thanks. Darrell Mozingo

 

[japes89]

Yes,

It can be &quot;select * from <table> order by datefield, timefield DESC &quot;

Thats it. _______________________________________________
OutsideIntranets.com
Stop wasting time, get to work

http://www.outsideintranets.com

 

[mozingod]

Thanks.... I was trying ORDER BY date DESC and time DESC and variations of that Darrell Mozingo