Parag Jain
01/07/2025, 4:46 PMDATETIMECONVERT(DATETRUNC(millis, t1) - DATETRUNC(millis, t2), '1:MILLISECONDS:EPOCH', '1:<unit>:EPOCH')
?Mayank
Mayank
timestampdiff already in Pinot. For example: I can run this in quicstart: select timestampdiff(second, 100000000, 200000000) from airlineStatsMayank
datediffMayank
select timestampDiff(second, 100000000, 200000000) from airlineStats
select datediff('second', 100000000, 200000000) from airlineStatsMayank
datediff has to be quoted for it to be treated as literal. This is because timestampdiff is a SQL keyword, but datediff is not.Parag Jain
01/08/2025, 1:16 PM