Dear SQLiters,

I am trying to use CHECK constraint is column of a table to enforce datetime 
format and this works:

AcquisitionDate        TEXT CHECK (AcquisitionDate IS date(AcquisitionDate))

when I insert '2015-08-10'. But this

AcquisitionDateTime  TEXT CHECK (AcquisitionDateTime IS 
datetime(AcquisitionDateTime))

when I insert '2015-08-10T17:19:37.670' or '2015-08-10 17:19:37.670' fails. 
Why? How to do it properly?

Thank you,

Roman

Reply via email to