2.1.1.29 F051-07, LOCALTIME

  • Article

V0029:

The specification states the following:

 Subclause 6.32, "<datetime value function>": The <current local time 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 local time value function> ::=
 LOCALTIME [ <left paren> <time precision> <right paren> ]
  
 Subclause 6.31, "<datetime value expression>": When the value is a <current local time value function>
  
 <datetime value expression> ::=
 <datetime term>
 | <interval value expression> <plus sign> <datetime term>
 | <datetime value expression> <plus sign> <interval term>
 | <datetime value expression> <minus sign> <interval term>
  
 Subclause 11.5, "<default clause>": LOCALTIME option of <datetime value function>
  
 <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>

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

Transact-SQL does not support this feature. See the datetimeoffset data type [MSDN-datetimeoffset] for equivalent functionality.