DateTime syntax in SQL

Open Delog-ru opened this issue 5 years ago • 1 comments

Can't figure out how to construct SQL expression with DateTime. SELECT $ FROM Protocols Where created > "2020-04-01T00:00:00.00Z"; doesn't work properly. It just shows everything. Field "created" is indexed.

Apr 17 '20 09:04 Delog-ru

@Delog-ru Something like SELECT $ FROM Protocols Where created > DATETIME('2020-04-01T00:00:00.00Z') should work

Apr 17 '20 13:04 lbnascimento