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
preguntada hace 3 años195 visualizaciones
1 Respuesta
0

Tried again with

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

MarkPar
respondido hace 3 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas