Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jacek Osuchowski Do you know your getdate()? RE: Do you know your getdate()?

  • July 8, 2010 at 3:37 am

    #1190088

    Very interesting.

    3750

    3.336

    Microsoft SQL Server 2005 - 9.00.4028.00 (Intel X86)

    Oct 20 2008 19:45:04

    Copyright (c) 1988-2005 Microsoft Corporation

    Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

    Big load going on with my 2008 server, so results are probably whacky.

    --GETDATE

    700

    15.6286

    --SYSDATETIME

    963

    15625

    Microsoft SQL Server 2008 (RTM) - 10.0.1763.0 (X64)

    Sep 18 2008 20:59:12

    Copyright (c) 1988-2008 Microsoft Corporation

    Developer Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/