I have a SQLite table with a DATETIME column that datasette-graphql maps as a Float field which all seems reasonable. In SQLite the column contains data like '2021-09-01 15:43:00.000' and trying to query this field yields "Float cannot represent non numeric value: '2021-09-01 15:43:00.000'".
I have a SQLite table with a DATETIME column that datasette-graphql maps as a Float field which all seems reasonable. In SQLite the column contains data like '2021-09-01 15:43:00.000' and trying to query this field yields "Float cannot represent non numeric value: '2021-09-01 15:43:00.000'".
I'm not exactly sure how to address this.
Thoughts?