How to sort date field in descending order
I have query which is returning rows in ascending order wher i am doing ...
select to_char(insert_dt ,'MM/DD/YYYY') as insert_dt from table
order br insert_dt desc
This query returns date in asc order but i want rows in desc order where i will get recent date..i know i can change query by replacing order by insert_dt asc but i want to use same query but should return right row...
select to_char(insert_dt ,'MM/DD/YYYY') as insert_dt from table
order br insert_dt desc
This query returns date in asc order but i want rows in desc order where i will get recent date..i know i can change query by replacing order by insert_dt asc but i want to use same query but should return right row...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.