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
asked 3 years ago181 views
1 Answer
0

Tried again with

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

MarkPar
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions