CODEWITHSUNDEEP
sql-server
Jin Yong
Jin Yong

Reputation: 43788

Convert datetime variable into string in SQL Server

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

Upvotes: 0

Views: 1461

Answers (1)

anishMarokey
anishMarokey

Reputation: 11387

try this:

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

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

Upvotes: 4

Related Questions