Using GetUTCDate in SQL Server CE 4
Consider a SQL Server CE 4 table with a non-nullable column: FooDate
. The goal is to have the current U开发者_运维百科TC datetime as the default.
The function is not recognized by SQL Server Compact. Name of function GetUTCDate.
The function GetDate()
works as expected as a default to a datetime
column in SQL Server Compact 4.
Is GetUTCDate()
supported in SQL Server CE 4 at all?
SQL Server CE supports a limited subset of T-SQL functions. GetUTCDate() is not one of them.
精彩评论