Re: [sqlite] DateTimeOffset in SQLite

2011-10-14 Thread Steffen Mangold
No solution? :( Joe can you help perhaps? You help me so much with my other problem with the Entity Framework. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DateTimeOffset in SQLite

2011-10-13 Thread Steffen Mangold
Pavel wrotes: > > I don't know C#, but quick look at Microsoft's documentation shows that you > can get Ticks() from TimeSpan, save it into DB and then when you get Int64 > from DB you can create TimeSpan from it. > Seems not to work entity framework cannot convert "long" to the type

Re: [sqlite] DateTimeOffset in SQLite

2011-10-12 Thread Pavel Ivanov
On Wed, Oct 12, 2011 at 9:08 AM, Steffen Mangold wrote: > > Igor Tandetnik wrote: > >>What's DateTimeOffset? Offset from what to what? What exactly are you trying >>to achieve? >>See if this helps: http://www.sqlite.org/lang_datefunc.html > > In C# (.Net) it is the

Re: [sqlite] DateTimeOffset in SQLite

2011-10-12 Thread Steffen Mangold
Igor Tandetnik wrote: >What's DateTimeOffset? Offset from what to what? What exactly are you trying >to achieve? >See if this helps: http://www.sqlite.org/lang_datefunc.html In C# (.Net) it is the type Timespan. I want to save a timespan in the DB and get an TimeSpan object in .Net out of the

Re: [sqlite] DateTimeOffset in SQLite

2011-10-06 Thread Igor Tandetnik
Steffen Mangold <steffen.mang...@balticsd.de> wrote: > how to use DateTimeOffset with Sqlite, if it is possible? What's DateTimeOffset? Offset from what to what? What exactly are you trying to achieve? See if this helps: http://www.sqlite.org/lang_datefunc.html -- Igor

[sqlite] DateTimeOffset in SQLite

2011-10-06 Thread Steffen Mangold
Hi all, how to use DateTimeOffset with Sqlite, if it is possible? Regards Steffen Mangold ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users