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
gefragt vor 3 Jahren195 Aufrufe
1 Antwort
0

Tried again with

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

MarkPar
beantwortet vor 3 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen