I am trying to run an automated job that grabs data every half hour from a table. I am hosting this downloaded data in mySQL but the source is DB2. The code for the query currently looks something like this:

Code:
SELECT
ABCDEF.PLAYERS
WHERE
ABCDEF.ENDDATTIM 
BETWEEN 
NOW() AND SUBTIME(NOW(), '0 0:30:0.000000')
Unfortunately this mySQL code (the SUBTIME())is not recognized by the DB2, I was...