Validate Date Time value on Sqlite before insert / update -

Validate Date Time value on Sqlite before insert / update -

as know right format date , time value in sqlite :

2014-06-18 01:00:00

my question : there method validate date , time value before insert / update on sqlite, maybe when creating table, create sure date , time info correct, thanks

to enforce value in any of supported formats, check built-in date function able parse it:

create table mytable( mydate check (date(mydate) not null), [...] );

sqlite