How cast Entity Framework Date into SQL Server Date with no time part

Question

I have a date value like '2012/01/01 12:36:55' and I want to filter SQL Server date value from this like '2012/01/01'

I can convert('2012/01/01 12:36:55', date, 102) in SQL Server to get '2012/01/01' value.

The question is : how can I convert date 2012/01/01 12:36:55' in EF LINQ query to get '2012/01/01' value when my source object still is Queryable ?

Did you ever solve this?

Sean Thorburn
– Sean Thorburn

2016-02-12 20:06:59 +00:00
Commented Feb 12, 2016 at 20:06 — Sean Thorburn
– Sean Thorburn, Commented Feb 12, 2016 at 20:06

Mohammad Kani · Accepted Answer · 2023-08-13 22:01:48Z

5

I Use EntityFunctions Class in System.Data.Objects namespace, and it works very well

public static class EntityFunctions

http://msdn.microsoft.com/en-us/library/system.data.objects.entityfunctions.aspx

http://msdn.microsoft.com/en-us/library/bb738626.aspx

edited Aug 13, 2023 at 22:01

answered Jul 2, 2012 at 9:24

Mohammad Kani

9468 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How cast Entity Framework Date into SQL Server Date with no time part

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related