Question Parameshwaran M... · 4 hr ago How to split the two timestamp based on interval time in IRIS Database? SELECT COALESCE(SUM(CASE WHEN service_log.value_after_changing = 'GENERATE' THEN 1 ELSE 0 END), 0) AS generatedCount, #Databases #Database Transaction Processing #Data Import and Export #Distributed Data Management #InterSystems API Manager (IAM) #InterSystems Business Solutions and Architectures #IRIS Analytics Architect #Java #InterSystems IRIS 0 8 0 40