Hey all. I use Node-Red to populate my databse and have a field called Timestamp where I store the creation data as a timestamp 1648719718809 = Thursday, March 31, 2022 9:41:58.809 AM
How can I use the timestamp to show data older than 3 days? What I mean is I know I have to use WHERE currenttimestamp - timestamp > 259,200 being 86400 is one day and thus 3 times that is 3 days. But how do I get the current time stamp value into the where statement