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()?

  • May 12, 2010 at 4:22 pm

    #1166571

    Jeff Moden (5/12/2010)

    Joe Celko (5/12/2010)

    I just wish that Microsoft has used the ISO/ANSI Standard CURRENT_TIMESTAMP and CURRENT_DATE instead of more dialect. Of course, they are going to have trouble with TIMESTAMP(n) thanks to the old Sybase Code Museum 🙂

    I haven't checked the other versions of SQL Server but SELECT CURRENT_TIMESTAMP works just fine in 2k5.

    I works in 2000 as well. Anyone have 7.0 or 6.5 to test?

    ---------------------------------------------------------------------
    Use Full Links:
    KB Article from Microsoft on how to ask a question on a Forum