• Danny Ocean (3/21/2013)


    Hi,

    Sorry, but i am unable to understand question completely.:ermm:

    If you increase varchar length then it will give right answer. Please try below T-sql statements

    SELECT CONVERT(VARCHAR,GETDATE(),20)

    SELECT CONVERT(VARCHAR,GETDATE(),21)

    SELECT CONVERT(VARCHAR,GETDATE(),106)

    SELECT CONVERT(VARCHAR,GETDATE(),107)

    SELECT CONVERT(VARCHAR,GETDATE(),109)

    SELECT CONVERT(VARCHAR,GETDATE(),113)

    The question is not about the statements executing correctly, but if the result of the CONVERT is deterministic. And that means that the CONVERT always should return the same result, independent of the language or any other setting. This is e.g. not the case with dates having month names in it.