SQL provides a number of different date formatting options. Use getdate() to get the date
then convert to a string and format as desired.

Number:  SQL Query:                                          Sample: 
1             select convert(varchar, getdate(), 1)      12/28/09 
2             select convert(varchar, getdate(), 2)      09.12.28 
3             select convert(varchar, getdate(), 3)      28/12/09 
4             select convert(varchar, getdate(), 4)      28.12.09 
5             select convert(varchar, getdate(), 5)      28-12-09 
6             select convert(varchar, getdate(), 6)      28 Dec 09 
7             select convert(varchar, getdate(), 7)      Dec 28, 09 
10           select convert(varchar, getdate(), 10)    12-28-09 
11           select convert(varchar, getdate(), 11)    09/12/28 
101         select convert(varchar, getdate(), 101)   12/28/2009 
102         select convert(varchar, getdate(), 102)   2009.12.28 
103         select convert(varchar, getdate(), 103)   28/12/2009  
105         select convert(varchar, getdate(), 105)   28-12-2009 
107         select convert(varchar, getdate(), 107)   Dec 28, 2009 
110         select convert(varchar, getdate(), 110)   12-28-2009 
111         select convert(varchar, getdate(), 111)   2009/12/28
Other variations are also available.

Keep in mind you need to do any calculations before you convert to string.