Export (0) Print
Expand All
Expand Minimize
2 out of 4 rated this helpful - Rate this topic

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.


GETDATE ( )

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());
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.