2.1.1.17 E141-07, Column defaults

V0017:

The specification states the following:

 Subclause 11.4, "<column definition>": With <default clause>
  
 <column definition> ::=
 <column name> [ <data type or domain name> ]
 [ <default clause> | <identity column specification> | <generation clause> ]
 [ <column constraint definition>... ]
 [ <collate clause> ]
  
 Subclause 11.5, "<default clause>":
  
 <default clause> ::=
 DEFAULT <default option>
  
 <default option> ::=
 <literal>
 | <datetime value function>
 | USER
 | CURRENT_USER
 | CURRENT_ROLE
 | SESSION_USER
 | SYSTEM_USER
 | CURRENT_CATALOG
 | CURRENT_SCHEMA
 | CURRENT_PATH
 | <implicitly typed value specification>
  
 Subclause 6.32, "<datetime value function>":
  
 <datetime value function> ::=
 <current date value function>
 | <current time value function>
 | <current timestamp value function>
 | <current local time value function>
 | <current local timestamp value function>
  
 <current date value function> ::=
 CURRENT_DATE
  
 <current time value function> ::=
 CURRENT_TIME [ <left paren> <time precision> <right paren> ]
  
 <current local time value function> ::=
 LOCALTIME [ <left paren> <time precision> <right paren> ]
  
 ...
  
 <current local timestamp value function> ::=
 LOCALTIMESTAMP [ <left paren> <timestamp precision> <right paren> ]

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL partially supports this feature. However, the CURRENT_DATE, CURRENT_TIME, LOCALTIME, and LOCALTIMESTAMP value functions are not supported in DEFAULT expressions.