How do I retrieve the event logs that have been logged in the
past 10 minutes?
You need to use the SUB
function to subtract 10 minutes from the current UTC timestamp returned by the
SYSTEM_TIMESTAMP function, and
convert this timestamp to local time using the TO_LOCALTIME function:
SELECT *
FROM System
WHERE TimeGenerated >= TO_LOCALTIME( SUB( SYSTEM_TIMESTAMP(), TIMESTAMP( '10', 'mm' ) ) )
沒有留言:
張貼留言