Convert datetime variable into string in SQL Server

Question

Anyway I can convert a datetime variable into string in SQL Server?

Answer 1

try this:

select convert(varchar(100),getdate(),110)

http://msdn.microsoft.com/en-us/library/ms187928.aspx