

SELECT convert(varchar(30),getdate(),112)