Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-27-2025 03:33 AM
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