Query dsl max(date)-min(date)


(suresh) #1

hi,
sample
id,reqtime,resptime,batch
1,18/9/2018 2:30, 18/9/2018 2:31,batch-44
2,18/9/2018 2:32, 18/9/2018 2:33,batch-44

result:
18/9/2018 2:33 - 18/9/2018 2:30 = 180sec

i want prepare query for this is there any way we can do the difference between the max(date)-min(date)
from required total documents.


(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.