Dohsan (3/31/2010)
SELECT CONVERT(VARCHAR(10), GETDATE(), 120) AS DT
If you do a quick search you should be able to find a few sites with lists of the different date formats using CONVERT.
Have a quick look over: http://www.sql-server-helper.com/tips/date-formats.aspx
Thanks for this information.
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together