DB2 Question

  • Thread starter Thread starter Nick
  • Start date Start date
N

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)
 
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
 
Back
Top