Post reply

What are the DateTime Conversion Function not supported in SQL Server 2005 but supported in SQL Server 2000

  • May 12, 2009 at 7:46 am

    #155692

    In SQL Server 2005 what are the DateTime Conversion function is not SUPPORTED.

    Example:: CONVERT(VARCHAR(20),GETDATE(),109)

    Please suggest.

    Thanks and Regards

    Sumanta Panda

    Tcs

  • May 12, 2009 at 7:55 am

    #992937

    You can find all the formats that are supported in the Date and Time Styles section on Cast and Convert on msdn. (I think this is what you were asking for)

    http://msdn.microsoft.com/en-us/library/ms187928.aspx

  • May 12, 2009 at 8:14 am

    #992972

    It's not very clear what you are asking, but in fact

    SELECT CONVERT(VARCHAR(20),GETDATE(),109)

    really works and returns the value in the expected format: "May 12 2009 10:07:07"

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply