Hello Pradeep,

Using order by birth_date will not solve my problem,

consider the following table

One | 02/18/1981
Two | 02/17/1985
Three | 03/27/1976
Four | 02/21/1970
Five | 02/16/1986
Six | 07/15/1981


I want output as

02/15/1986 i.e. Feb 16
02/16/1985 i.e. Feb 17
02/18/1981 i.e. Feb 18
02/21/1970 i.e. Feb 22

But using order by birth_date will give me out put as

02/21/1970 i.e. Feb 22
02/18/1981 i.e. Feb 18
02/16/1985 i.e. Feb 17
02/15/1986 i.e. Feb 16

Which i dont want in this order, as days and month are not in order.

Any other option?

Thanks
Khwab