Problem with a timestamp query???

[mluken]

I am able to run this query in access directly, but when I call it from my java application ot gives me an error - do I need this timestamp formatted differently or something of that nature???

DELETE FROM DB2_APPNAME_PNDING_PROF_OWNRSHP WHERE TS < #12/09/2004 05:35:03 PM# AND USR_ID <> 0

Error message:

A database manager error occurred.
SQL State: 07001
[Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect
com.ibm.db.DataException: A database manager error occurred. : [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect

Thanks!

 

[PHV]

You may try replace this:
#12/09/2004 05:35:03 PM#
By this:
{ts '2004-12-09 17:35:03'}

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244