HOW CAN I QUERY A SPECIFIC DATA?

Kadirhan Gözükoca 0
Viewed 59

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"
tsql google-bigquery sql
3 Answers

Maybe it can help you

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

You can test here

hlyza180

I think you can get parameters:

Where event_date > "2022-09-02" and "2022-09-04" < event_date
Rezky0

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

umegha kekuda0
Related