[sqlite] Fix for non unix times DATETIME

2015-07-11 Thread Lee Reiber
Joe That worked wonderfully. As you said I will have to take into account the various types (e.g., TIMESTAMP,DATETIME,TIME) but it fits my need well. Thank you! Lee On Fri, 10 Jul 2015 at 17:34 Joe Mistachkin wrote: > > Lee Reiber wrote: > > > > Is there a way on connectio

[sqlite] Fix for non unix times DATETIME

2015-07-10 Thread Lee Reiber
More to the first post than the second yes On Fri, Jul 10, 2015, 11:32 AM Simon Slavin wrote: > > On 10 Jul 2015, at 6:12pm, Lee Reiber wrote: > > > Searching for many days on a fix to the dreaded DATETIME mapping to .NET. > > My guess is that this is a reference to &g

[sqlite] Fix for non unix times DATETIME

2015-07-10 Thread Lee Reiber
Searching for many days on a fix to the dreaded DATETIME mapping to .NET. Of course SQLite technically does not have a datetime per-say as I clearly understand but the problem remains with dates such as Mac absolute and also Java datetimes. The fun "string cannot be converted to string" is what I