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

2017-11-02 Thread David Raymond
qlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, November 02, 2017 10:19 AM To: SQLite mailing list Subject: Re: [sqlite] [EXTERNAL] SQLite DB - DateTime field values are not consistent On 11/2/17, David Raymond wrote: > For basic level you c

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

2017-11-02 Thread nomad
On Thu Nov 02, 2017 at 10:18:41AM -0400, Richard Hipp wrote: > On 11/2/17, David Raymond wrote: > > For basic level you can use a check constraint > > > > create table Table1 ( > > TestDate DATETIME > > check (TestDate like '-__-__ __:__:__' > >and datetime(TestDate) is not n

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

2017-11-02 Thread Richard Hipp
On 11/2/17, David Raymond wrote: > For basic level you can use a check constraint > > create table Table1 ( > TestDate DATETIME > check (TestDate like '-__-__ __:__:__' >and datetime(TestDate) is not null) > ); > > That should check that it's in the correct format, and the se

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

2017-11-02 Thread David Raymond
m: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Hick Gunter Sent: Thursday, November 02, 2017 8:39 AM To: 'SQLite mailing list' Subject: Re: [sqlite] [EXTERNAL] SQLite DB - DateTime field values are not consistent There is no "date" datatyp

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

2017-11-02 Thread Hick Gunter
There is no "date" datatype in SQLite, an das you yourself attest, SQLite is returning exactly whatever was originally inserted. It is up to your application to define the allowed format for storing datetimes and to provide conversion between the chosen storage format and the presentation to th