Ver formatos de fecha en SQL Server

FormatDate

declare @dob2 DATETIME=getdate()

select convert(varchar, @dob2, 101)--01/26/2015
select convert(varchar, @dob2, 102)--2015.01.26
select convert(varchar, @dob2, 103)--26/01/2015
select convert(varchar, @dob2, 104)--26.01.2015
select convert(varchar, @dob2, 105)--26-01-2015
select convert(varchar, @dob2, 106)--26 Jan 2015
select convert(varchar, @dob2, 107)--Jan 26, 2015
select convert(varchar, @dob2, 108)--10:52:40
select convert(varchar, @dob2, 109)--Jan 26 2015 10:52:40:380AM
select convert(varchar, @dob2, 110)--01-26-2015
select convert(varchar, @dob2, 111)--2015/01/26
select convert(varchar, @dob2, 112)--20150126
select convert(varchar, @dob2, 113)--26 Jan 2015 10:52:40:380