Hai

I need to know how to format the date as the following by using the sql
query. is there any functions to format the date as the following.

12-dec-2001

Thanks
Usha