GETDATE (SQL Server Compact)
Returns the current system date and time in the standard internal format for datetime values that are supported by SQL Server Compact.
Syntax
GETDATE ( )
Return Value
datetime
Example
The following example uses GETDATE to supply information for a date column.
CREATE TABLE MyOrders (OrderID int IDENTITY(100, 1) PRIMARY KEY, CompanyName nvarchar(50), OrderDate datetime);
INSERT INTO MyOrders (CompanyName, OrderDate) VALUES ('A. Datum Corporation', GETDATE());