Set the date right..?

[kenjoswe]

Hi all,

How can I set the date correct in SQL-server/query analyzer?
I want the date to be yyyy-mm-mm.
But I get: Oct 17 2001

The Set Dateformat only affect the current query.

/Kent J.

 

[rac2]

See Books Online topic CONVERT for available display styles for DATETIME datatypes. Internally the date is stored like it is stored, we only ever see a display format.

For example, to see a date displayed like yyyymmdd

SELECT CONVERT(CHAR(8), importantDate, 112) FROM etc.

Or, to see yyyy-mm-dd

SELECT SUBSTRING(CONVERT(VARCHAR(20), importantDate, 120), 1, 10) FROM etc.