DB2 Question

[Nick]

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:

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 looking for an equivalent in DB2 and could not find anything online. Does
anyone have a suggestion?

Thank you. (I couldn't find anyone in DB2 forums to respond, hoping someone
here can help)

 

[Michel Walsh]

Well, seems you should ask in an mySQL newsgroup, this is an MS Access
newsgroup. Jet will use DateAdd( ), with a negative value, since Jet does
not have a DateSubtract( ). It will use

DateAdd("n", -30, Now( ) )

or simply:

Now( ) - #00:30:00#



Vanderghast, Access MVP