This topic has not yet been rated - Rate this topic

SqlFunctions.DateAdd Method

.NET Framework 4

.NET Framework 4.5

Returns a new datetime value based on adding an interval to the specified date.

This member is overloaded. For complete information about this member, including syntax, usage, and examples, click a name in the overload list.

Overload List

	Name	Description
	DateAdd(String, Nullable<Double>, Nullable<DateTime>)	Returns a new datetime value based on adding an interval to the specified date.
	DateAdd(String, Nullable<Double>, Nullable<DateTimeOffset>)	Returns a new date value based on adding an interval to the specified date.
	DateAdd(String, Nullable<Double>, Nullable<TimeSpan>)	Returns a new time span value based on adding an interval to the specified time span.
	DateAdd(String, Nullable<Double>, String)	Returns a new datetime value based on adding an interval to the specified date.

Top

Remarks

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see DATEADD (Transact-SQL).

Reference

SqlFunctions Class

System.Data.Objects.SqlClient Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD