select convert(varchar(12) , getdate(), 111 ) as '1'
--2007/01/26

select convert(varchar(12) , getdate(), 112 ) as '2'
--20070126

select convert(varchar(12) , getdate(), 102 ) as '3'
--2007.01.26

select convert(varchar(12) , getdate(), 101 ) as '4'
--01/26/2007

select convert(varchar(12) , getdate(), 103 ) as '5'
--26/01/2007

select convert(varchar(12) , getdate(), 104 ) as '6'
--26.01.2007

select convert(varchar(12) , getdate(), 105 ) as '7'
--26-01-2007

select convert(varchar(12) , getdate(), 106 ) as '8'
--26 jan 2007

select convert(varchar(12) , getdate(), 107 ) as '9'
--jan 26, 2007

select convert(varchar(12) , getdate(), 108 ) as '10'
--10:10:09

select convert(varchar(12) , getdate(), 109 ) as '11'
--jan 26 2007

select convert(varchar(12) , getdate(), 110 ) as '12'
--01-26-2007

select convert(varchar(12) , getdate(), 113 ) as '13'
--26 jan 2007 

select convert(varchar(12) , getdate(), 114 ) as '14'
--10:10:09:530