In the database the traps table has timestamps in the local time zone of the Orion server that received the trap. SWIS operates in UTC, so the SWQL query equivalent to your SQL query would be:
SELECT COUNT(TrapID) AS MYCOUNT
WHERE DateTime > AddMinute(-10, GetUtcDate())
Do you get closer results with that query?
It does. Thank you!