Comparing dates in Entity SQL

Question

What is the correct eSQL syntax to compare dates?

The equivalent LINQ-to-Entities expression would look something like this:

var lastYearsShipments = from p in MyDataServiceContext.Products
                         where p.ShipDate.Value.Year == DateTime.Now.Year - 1
                         select p;

Community · Accepted Answer · 2017-05-23 12:01:24Z

2

They say it's acceptable to answer your own question, so here goes ...

var predicate = string.Format(
    "Year(it.ShipDate) == Year(cast('{0}' as System.DateTime)) -1",
    System.DateTime.Now);

var lastYearsShipments = 
    myQuery.Products.Where(predicate); // myQuery is type ObjectQuery<T>

Comments

stealthyninja · Accepted Answer · 2012-01-05 18:59:12Z

0

string datetimeFormatter = "yyyy-MM-dd HH:mm";

var predicate = string.Format("Year(it.ShipDate) == Year(DATETIME'{0}')) -1", System.DateTime.Now.ToString(datetimeFormatter)); 

var lastYearsShipments = myQuery.Products.Where(predicate);

edited Jan 5, 2012 at 18:59

stealthyninja

10.4k11 gold badges57 silver badges61 bronze badges

answered Mar 25, 2010 at 16:47

Vicente

1

Collectives™ on Stack Overflow

Comparing dates in Entity SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related