Hi everyone ! I would like to know if there is a way to take the current time and the time 5 minutes ago. That is to say, currently it is 15:10 I keep in a variable, and I want to take also 15:05 and leave in a variable.
I am making a query in SQL Oracle that does not allow me to get the 5 minutes before using this statement.
TO_DATE(FV.FEC_LOAD, 'MM/DD/YYYY HH24:MI:SS') >= SYSDATE - 5/(24*60)
If I put a condition where I put current time and time 5 minutes later, manually, it works perfect.
Is there way to do this? thank you
Solved! Go to Solution.
Use the expression:
You may need to wrap this in a formatDateTime expression to get the format you need. Let me know if you need extra assistance.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.