: Thursday, May 30, 2013 9:45 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
eschneider FE
>
> Solved it.
>
Great. I'm curious, which connection string properties did you end up
using?
>
> You cannot
Could treat it as datetime
-Original Message-
From: Joe Mistachkin
Sent: 5/30/2013 9:44 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
eschneider FE
>
> Solved it.
>
Great. I'm curious, which connecti
eschneider FE
>
> Solved it.
>
Great. I'm curious, which connection string properties did you end up
using?
>
> You cannot use parameter DbType.DateTime2 and must use DbType.DateTime
for
> the lib to format the date upon insert.
>
Right, DbType.DateTime2 is not recognized by
:21 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
Joe,
So are you say we can specify the exact format string in the connection
string?
How would that look?
; DateTimeFormatString='XXX'
Would I need to download a new
eschneider FE wrote:
>
> So are you say we can specify the exact format string in the connection
> string?
>
As of yesterday, yes.
>
> How would that look?
> ; DateTimeFormatString='XXX'
>
Probably something like:
"Data
-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Wednesday, May 29, 2013 9:58 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
eschneider FE wrote:
>
> Just realized I left in the work around code, the date issue is
'General Discussion of SQLite Database'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
Eric Schneider wrote:
>
> That's. For parsing, what about inserts?
>
5/25/2013 1:18:20 PM
The new connection string property should apply to any operation that
requires
conver
That connection string mod doesn't seem to help. Let me know what you need from
me to clarify.
-Original Message-
From: Joe Mistachkin
Sent: 5/29/2013 9:57 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
eschneider
Eric Schneider wrote:
>
> That's. For parsing, what about inserts?
>
5/25/2013 1:18:20 PM
The new connection string property should apply to any operation that
requires
converting a string to a DateTime or vice-versa (e.g. parsing or
formatting).
When inserting a row using a parameterized
That's. For parsing, what about inserts?
-Original Message-
From: Joe Mistachkin
Sent: 5/29/2013 9:57 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
eschneider FE wrote:
>
> Just realized I left in the work
eschneider FE wrote:
>
> Just realized I left in the work around code, the date issue is still a
> problem.
>
I'm still not sure exactly what the problem actually is. That being said,
I've just added a new connection string property named DateTimeFormatString
to give people full control over
'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
The default is a non-working default though.
So inserting using best practices of SQL statement & parameters does not
work, and queries also.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sq
sday, May 29, 2013 6:13 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
eschneider FE wrote:
>
> Ok; re-reading last and saw connection string. So adding ;DateTimeKind=
> DateTimeKind.Utc to connection string wor
eschneider FE wrote:
>
> Ok; re-reading last and saw connection string. So adding ;DateTimeKind=
> DateTimeKind.Utc to connection string works. Why isn't this the default?
>
Primarily because making it the default would alter the behavior in a very
subtle and non-backward compatible way.
--
, May 29, 2013 5:39 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
I understand that Joe, but if I'm inserting using parameters; the Sqlite
.net lib is determining the format not me the developer, I'm just passing in
a DateTime
Of Joe Mistachkin
Sent: Wednesday, May 29, 2013 4:37 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] .net Sqlite lib reading date fields not working?
eschneider FE wrote:
>
> So when using System.Data.SQLite and inserting data using a parameter of
> datetime,
eschneider FE wrote:
>
> So when using System.Data.SQLite and inserting data using a parameter of
> datetime, I believe the System.Data.SQLite .net lib is doing a ToString()
on
> datetime when it should be using a specific date format supported by
SQlite.
>
The DateTime parsing and formatting
...@frozenelephant.com]
Sent: Tuesday, May 28, 2013 1:36 PM
To: 'sqlite-users@sqlite.org'
Subject: RE: .net Sqlite lib reading date fields not working?
I am not getting your replies Keith; I'm new so maybe it's just delayed.
To clarify, I think this is a .NET Sqlite lib problem, not a database issue
I am not getting your replies Keith; I'm new so maybe it's just delayed.
To clarify, I think this is a .NET Sqlite lib problem, not a database issue;
sorry for the confusion.
I am currently inserting the data with the Sqlit .NET library using sql with
a parameter of datetime type, so If the date
19 matches
Mail list logo