The syntax looks correct. How is it not working? Are you getting an exception or an empty result set?
On Feb 1, 2008 12:37 PM, ppakk <[EMAIL PROTECTED]> wrote: > Hi, > > I am using ibatis with DB2 and am doing a > query to see if a row of data has been created > in the past 24 hours. This query is not working. > Does anyone know what the correct syntax is? > > thank you > Paul > > > <![CDATA[ > > SELECT ITEM_UID > FROM NEWS_DATA > WHERE CREATED_DATE > (CURRENT TIMESTAMP - 24 HOUR) > ]]> > > > CREATED_DATE is a TIMESTAMP column > > > > > ____________________________________________________________________________________ > Never miss a thing. Make Yahoo your home page. > http://www.yahoo.com/r/hs >
