I'm trying to see whether this timestamp was in the last 24 hours but because the type is seen as a string it won't let me check it with Date and lt etc.
What am I missing? Thanks.
Solution
Sorry for long response @Matt. You might convert this field into date in your application and do your filters.
Also, there will be soon
date
date
mode for the
text
text
data type in sqlite, so this field will be already returned as Date object from drizzle.