How to search a column named "date"

0

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

MarkPar
已提问 3 年前195 查看次数
1 回答
0

Tried again with

Select * FROM mydatastore WHERE date = '12/8/20' and it worked. No idea why it kept rejecting before.

MarkPar
已回答 3 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则