Documents Created in last 5 min

Jan 16 2025 5:34 AM

I have below code and Time is system is stored as below in Database . I want Documents created in last 5 min from Current Date and Time.. If now is 17:00 than I need documents added from 16:55 till 17:00

Query is in Hana version

14:37

15:36

SELECT 
T0."DocDate" "Doc. Date",  

T1."Remarks" FROM OWDD T0 inner 
join WDD1 T1 on T1."WddCode" = T0."WddCode"
where T1."Status" = 'W'

Thanks

Answers (1)

Replace Max function to get 1 record