• 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