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