HOW CAN I QUERY A SPECIFIC DATA?-CodePudding

I wanna see the event_date = "2022-09-03" data's but I don't know how can i do it. Could you pls help me? Data is like this : event_date: 2022-09-03 09:33:54.873010 UTC Example Data:

My Query is: SELECT

event_date
FROM
  `my-data-source`
WHERE
 event_date = "2022-09-03"

CodePudding user response：

i think you can get parameters Where event_date > "2022-09-02" and "2022-09-04" < event_date

CodePudding user response：

select * from my-data-source where cast(event_date as date)='2022-09-03'

CodePudding user response：

Maybe it can help you

SELECT LEFT('2022-09-03 09:33:54.873010 UTC', 10)

You can test here