timestamp date filter does not work

collierd
New Contributor III

Hello

I have a column called LastUpdated defined as timestamp

If I select from the table it displays as (e.g.) 2025-08-27T10:50:31.610+00:00

How do I filter on this without having to be specific with the year, month, day, ...

 

This does not work:

select * from available

where LastUpdated = '2025-08-27T10:50:31.610+00:00'

 

Feel like there's a better approach than

select * from available

where year(LastUpdated) = 2025

and month(LastUpdated) = 8

and day(LastUpdated) = 27

etc.
 
Thanks