Using GetUTCDate in SQL Server CE 4

Question

Consider a SQL Server CE 4 table with a non- FooDate column: FooDate . The goal is to have the current default UTC time set by default.

The function is not recognized by SQL Server Compact. The name of the function is GetUTCDate.

The GetDate() function works as expected by default in the datetime column in SQL Server Compact 4.

Is GetUTCDate() supported in SQL Server CE 4?

Answer 1

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