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
posta 3 anni fa195 visualizzazioni
1 Risposta
0

Tried again with

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

MarkPar
con risposta 3 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande