开发者

Using GetUTCDate in SQL Server CE 4

开发者 https://www.devze.com 2023-02-05 04:18 出处:网络
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.

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?

Using GetUTCDate in SQL Server CE 4


SQL Server CE supports a limited subset of T-SQL functions. GetUTCDate() is not one of them.

0

精彩评论

暂无评论...
验证码 换一张
取 消