Re: [sqlite] SQLite DB - DateTime field values are not consistent

2017-11-02 Thread Keith Medcalf
gt;-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Rajat Pal >Sent: Thursday, 2 November, 2017 06:24 >To: sqlite-users@mailinglists.sqlite.org >Cc: Joy George Chittilapailly; Minghua Feng; Rohit Udasi >Subject: [

Re: [sqlite] SQLite DB - DateTime field values are not consistent

2017-11-02 Thread Tim Streater
On 02 Nov 2017, at 12:23, Rajat Pal wrote: > In SQLite database, All the values of datetime fields are saved as text > without any format check. We can save any text value in the datetime column. > This behavior is creating problem for us because for different regional > settings, datetime value

Re: [sqlite] SQLite DB - DateTime field values are not consistent

2017-11-02 Thread Stephen Chrzanowski
As Hick mentioned, you could get your application to deal with this, or, if you want it at the SQLite level, you could get into triggers to analyze the data before its being inserted or updated. For me, it depends on how you want to look at the issue as far as what part of the entire application s

[sqlite] SQLite DB - DateTime field values are not consistent

2017-11-02 Thread Rajat Pal
Hi Team, We have identified an issue with SQLite database which seems to be a potential bug. In SQLite database, All the values of datetime fields are saved as text without any format check. We can save any text value in the datetime column. This behavior is creating problem for us becau