To get the desired result in your question use :
select * from table order by to_char(date_column,'D') ;
In the employees table we have hire_date column which is of datatype DATE.
select...
Type: Posts; User: tonyrobert; Keyword(s):
To get the desired result in your question use :
select * from table order by to_char(date_column,'D') ;
In the employees table we have hire_date column which is of datatype DATE.
select...