sql server 取date 及 time

select convert(varchar(10) , getdate(),112 ) as myDate, convert(varchar(8),getdate(),8) as myHour
回傳:20091105 17:44:57

select convert(varchar(10) , getdate(),121 ) as myDate, convert(varchar(8),getdate(),8) as myHour

回傳:2009-11-05 17:44:57