mercredi 6 janvier 2016

Changing a sql server query to sqlite

I'm converting a Sql Server query to sqlite and I am in the process of learning the SQLite queries. Regardless this is the one area that I am having a hard time with and that is the dates.

DATEADD(dd, 0, DATEDIFF(dd, 0, tblSomeTable.EventDate)) >= DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

What would the equivalent to this in sqlite be? Thank you in advance.

Aucun commentaire:

Enregistrer un commentaire