Simon Worth’s SQL Server Weblog

SQL Server and its many complexities

Archive for the ‘ANSI’ Category

SQL Server and CURRENT_TIMESTAMP

leave a comment »

CURRENT_TIMESTAMP is part of the ANSI Standard while GETDATE() is a Microsoft implemented date and time function.  Denis Gobo over at http://sqlblog.com/blogs/denis_gobo shows what happens when you add CURRENT_TIMESTAMP as a default on a column.  Interesting stuff.  The post can be found here.  Thanks for sharing Denis.

http://sqlblog.com/blogs/denis_gobo/archive/2009/02/22/12089.aspx

Written by Simon Worth

February 23, 2009 at 8:21 am