Need to convert date to yyyy-mm-dd for XML

[jahooper]

I need to convert some dates to yyyy-mm-dd format for XML. I know the following:

convert(varchar,GetDate(),126) --> 2004-06-02T16:13:49.293

My question is, how do I get just the yyyy-mm-dd component without the time?

Thanks for any suggestions!

 

[TheBugSlayer]

SELECT CONVERT(VARCHAR(10),GETDATE(),120) is what you need. Good luck.

 

[jahooper]

Thanks for the quick tip. That did it!