[sqlite] datetime in CHECK

[Cecil Westerhof]

2016-05-05 2:48 GMT+02:00 Keith Medcalf <kmedcalf at dessus.com>:

>
> fails.  However, datetime(timestring) where timestring is an invalid ISO
> timestring returns NULL, so yout check constraint might likely be:  CHECK
> (datetime(col) is not null)
>

?I am afraid that is no true. The statement:
    SELECT strftime('%Y-%m-%d %H:%M:%f', '2016-04-31 17:19:59.670')
gives:
    2016-04-31 17:19:59.670

-- 
Cecil Westerhof