Then use-

Convert(char(10),getdate(), 120) -- for date

Convert(char(8),getdate(),114)-- For time

Replace getdate(), with our column name.