query for all tasks created today

[dominik42]

Hi,
I try to create a query (for the very beginning with my DB tool DBVisualizer) in order to count the tasks created today.
Something like
select * from TMTask where creationDate == date('now');
As I saw, column TMTask.creationDate is of type REAL and sqlite function date(...) can convert dates, but how I can combine both in order to archive my goal ?

After I got the query working, I hopefully can setup a plugin for using it together with the things.sh....

Kind regards
Dominik

[AlexanderWillner]

Cool. Thanks. You might want to consider to extend https://github.com/thingsapi/things-cli instead. It's an updated Python version of this tool.