vidhya sagar (10/28/2007)

---

[font="Courier New"]You can convert current date as you required by below piece of code

select convert(varchar(25),getdate(),101)

You can change the last variable value from 101 to 121 and each value...