[sqlite] DbFunctions.TruncateTime

On Sun, Aug 23, 2015 at 10:53 PM, Joe Mistachkin wrote: > > The LINQ provider for System.Data.SQLite does not provide this function > directly; however, it may be possible to use one of the core date-time > related SQL functions to do it? > > https://www.sqlite.org/lang_datefunc.html >

[sqlite] DbFunctions.TruncateTime

The LINQ provider for System.Data.SQLite does not provide this function directly; however, it may be possible to use one of the core date-time related SQL functions to do it? https://www.sqlite.org/lang_datefunc.html -- Joe Mistachkin

[sqlite] DbFunctions.TruncateTime

On 2015-08-23 12:16 AM, Steffen Mangold wrote: > Hi Ryan, > > I get your point. :) > It seems the I was misunderstanding this help mailing list. I thought it's > also support for 'System.Data.SQLite'. > > In the way 'System.Data.SQLite' is an ADO.NET provider for SQLite and also > give support

[sqlite] DbFunctions.TruncateTime

On 2015-08-22 10:57 PM, Steffen Mangold wrote: >> how can I trunc time in EntityFramework? >> >> I tried it this way: >> >> model.Datas >> .GroupBy(d => >> DbFunctions.TruncateTime(d.TimeStamp)) >> .Select(d => d.Key.Value) >>

[sqlite] DbFunctions.TruncateTime

Hi Ryan, I get your point. :) It seems the I was misunderstanding this help mailing list. I thought it's also support for 'System.Data.SQLite'. In the way 'System.Data.SQLite' is an ADO.NET provider for SQLite and also give support for entity framework. that because I was asking if it support

[sqlite] DbFunctions.TruncateTime

> > how can I trunc time in EntityFramework? > > I tried it this way: > > model.Datas >.GroupBy(d => > DbFunctions.TruncateTime(d.TimeStamp)) >.Select(d => d.Key.Value) >.ToArray(); > > But get this error: >

[sqlite] DbFunctions.TruncateTime

Hi, how can I trunc time in EntityFramework? I tried it this way: model.Datas .GroupBy(d => DbFunctions.TruncateTime(d.TimeStamp)) .Select(d => d.Key.Value) .ToArray(); But get this error: "SQLit