CODEWITHSUNDEEP
sql-server
Rod
Rod

Reputation: 15475

sql date convert to string format

How can I convert GETDATE() into a string like so: '2010-10-15'

-rod.

Upvotes: 6

Views: 2530

Answers (4)

parvezalam khan
parvezalam khan

Reputation: 490

Try below code which will convert your date for specific format

SELECT convert(varchar,Getdate(),23) -- YYYY-MM-DD
SELECT convert(varchar,Getdate(),105) -- DD-MM-YYYY
SELECT convert(varchar,Getdate(),110) --MM-DD-YYYY

Upvotes: 2

Brad
Brad

Reputation: 15577

SELECT CONVERT(VARCHAR(10), GETDATE(), 120)

By setting the varchar length, you can effectively truncate unwanted portions of the DateTime

CAST and CONVERT (Transact-SQL)

Upvotes: 6

TRAD
TRAD

Reputation: 1

Here is another way to do it, SELECT REPLACE(CONVERTrt(varchar(10),GETDATE(),111)'/','-')

Upvotes: 0

Randy Minder
Randy Minder

Reputation: 48522

Here a complext way to do it:

Select Convert(char(4),DATEPART(yy,GetDate())) + '-' + convert(char(2),DATEPART(mm,GetDate())) + '-' + Convert(char(2),DATEPART(dd,GetDate()))

An easier way is:

Select Convert(VARCHAR(10), GetDate(), 120)

You might want to take a look at the T-SQL Convert function. It allows you to format dates in many pre-defined ways:

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

Upvotes: 2

Related Questions