Hi @collierd ,

You have many options here. You can use 

1. Date Truncation - which returns timestamp truncated to the unit (you can use day, quarter, month etc)

%sql
SELECT 
   date_trunc('day', LastUpdated),
   LastUpdated
FROM (
  SELECT current_timestamp() as LastUpdated 
) src
WHERE date_trunc('day', LastUpdated) = '2025-08-27'

  2. You can use date casting 

SELECT 
   CAST(LastUpdated AS DATE) As lastUpdatedCasted,
   LastUpdated
FROM (
  SELECT current_timestamp() as LastUpdated 
) src
WHERE CAST(LastUpdated AS DATE) = '2025-08-27'

3. Range filtering

SELECT    
   LastUpdated
FROM (
  SELECT current_timestamp() as LastUpdated 
) src
WHERE LastUpdated >= '2025-08-27' 
  AND LastUpdated < '2025-08-28'

4. Format Matching

%sql
SELECT 
   date_format(LastUpdated, 'yyyy-MM'),
   LastUpdated
FROM (
  SELECT current_timestamp() as LastUpdated 
) src
WHERE date_format(LastUpdated, 'yyyy-MM') = '2025-08'