I have a time series data store in AWS IOT Analytics that looks like this
serial number, date, time, temp
2,12/15/2020,15:23:56,564
1,12/15/2020,15:25:56,458
7,12/15/2020,15:43:07,325
What I am trying to do is create a data set using the SQL query. Something like this
SELECT * FROM mydatastore WHERE date = 12/15/2020
I have two issues. First, how do I make it search for the column named "date" and not inerpret that as the date function? Second, how do I escape the "/" characters in the actual data so I can find the rows I need? I realize these are likely basic questions but I have not been able to find an answer anywhere else so far.
thanks