sql to oder by current date

Question

I am trying to roder a resultset based on Current date in Sybase ASE. I do not understand how to do that.

select x,date1 from abc where x>y order by date1> current_date

How to use the current date in orderby clause?

Answer 1

My mistake, i got the requirements wrong. it makes sence to just sort in Desc or asc and then work with the data. sometimes I tend to forget basic things when i am too busy. Thank you all for the responses.