开发者

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?

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜