a1mzone

Apache Druid

Query

SELECT 
    COUNT(*) AS total, 
    DATE_TRUNC('day', TIME_PARSE("created_at",'yyyy-MM-dd HH:mm:ss.S')) AS dom 
FROM source 
WHERE DATE_TRUNC('day', TIME_PARSE("created_at",'yyyy-MM-dd HH:mm:ss.S')) >= '2024-08-01' 

AND DATE_TRUNC('day', TIME_PARSE("created_at",'yyyy-MM-dd HH:mm:ss.S')) < CURRENT_DATE