How can I convert GETDATE() into a string like so: '2010-10-15'
-rod.
Add a comment
|
4 Answers
SELECT CONVERT(VARCHAR(10), GETDATE(), 120)
By setting the varchar length, you can effectively truncate unwanted portions of the DateTime
Comments
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
Comments
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
1 Comment
James Z
23 is not a documented option for convert, the others aren't what the OP asked for and the accepted answer from 2010 already has link for the documentation.
Here is another way to do it, SELECT REPLACE(CONVERTrt(varchar(10),GETDATE(),111)'/','-')
1 Comment
Gennady Vanin Геннадий Ванин
it contains excessive 'rt' in CONVERTrt and missing virgule before '/'
