Now() Equivalent in MSSQL

Use the Getdate() function in SQL Server instead of Now() in Access (and MySQL, I think).

Wow, it's shocking to see the limits of "standardized SQL".


Tags: date, time, database, mssql, sql server, tsql, function
Related Scribbles:
  • MSSQL trigger examples
    		•
  • SQL Server
    		•

    ID: 598
    Author:
    leonard
    Date Updated:
    2007-03-07 10:43:20
    Date Created:
    2005-01-20 10:22:16

    Edit
    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> Now() Equivalent in MSSQL
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.