DATE ONLY FORMATS 1 convert(varchar, getdate(), 1) mm/dd/yy 12/30/06 2 convert(varchar, getdate(), 2) yy.mm.dd 06.12.30 3 convert(varchar, getdate(), 3) dd/mm/yy 30/12/06 4 convert(varchar, getdate(), 4) dd.mm.yy 30.12.06 5 convert(varchar, getdate(), 5) dd-mm-yy 30-12-06 6 convert(varchar, getdate(), 6) dd-Mon-yy 30 Dec 06 7 convert(varchar, getdate(), 7) Mon dd, yy Dec 30, 06 10 convert(varcha..
