This topic has not yet been rated - Rate this topic

SqlFunctions.DatePart Method

.NET Framework 4

.NET Framework 4.5

Returns an integer that represents the specified datepart of 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
	DatePart(String, Nullable<DateTime>)	Returns an integer that represents the specified datepart of the specified date.
	DatePart(String, Nullable<DateTimeOffset>)	Returns an integer that represents the specified datepart of the specified date.
	DatePart(String, Nullable<TimeSpan>)	Returns an integer that represents the specified datepart of the specified date.
	DatePart(String, String)	Returns an integer that represents the specified datepart of 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 DATEPART (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 Content Add

FAQ