Fetch Only Date From Date field from SQL Ser. DB using linq?

Question

het frnds.. i want to get only date part from date field from a table of SQL Server using linq to SQL. Please..... Thanks...

Jignesh Trivedi · Answer

Hi I think Field type Datatime right? so datatime type has on property called Date. using this property you can get only date. Like var p = from l in context.DateExample select new { date1 = l.DateTimeFiled.Date } hope this will help you.