search

mbdavid / LiteDB.Studio

A GUI tool for viewing and editing documents for LiteDB v5
MIT License
799 stars 203 forks source link

DateTime syntax in SQL #21

Open Delog-ru opened 4 years ago

Delog-ru commented 4 years ago

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.

lbnascimento commented 4 years ago

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