order a query by days of week starting with monday

[gandolf989]

You can also subtract one day from the date field where Sunday becomes Saturday and Monday becomes Sunday hence it would sort the days from Monday to Sunday.

select * from XYZ order by to_char(buydate-1,'D') ;