According to IBM FileNet P8, Version 5.2
- SQL Syntax reference"
<literal> ::= <string_literal> | <integer> | <float> |
<ISO datetime> | <W3C datetime> | TRUE | FALSE | UNKNOWN | <guid>
<ISO datetime> ::= YYYYMMDDThhmmss[,ffff]Z
<W3C datetime> ::= YYYY-MM-DD[Thh:mm:ss[.ffff]][<timezone>]
Thus, in FileNet P8 do not use timestamp
or date
keywords, but only the date you have written in one of these formats, and note - without an apostrophe sign!
You can find examples in a free book Developing Applications
with IBM FileNet P8 APIs, for example on a page 73 there is Example 3-30
:
// Construct the sql statement
SearchSQL sql = new SearchSQL(
"select ISTOStartDate, ITSOEndDate, ITSOVehicle " +
"from ITSOIdleActivity " +
"where “ +
"ITSOVehicle = OBJECT('{D5DC8C04-2625-496f-A280-D791AFE87A73}') " +
"AND ITSOStartDate < 20090801T000000Z OR " +
"ITSOEndDate > 20090701T000000Z" );
As you see, the date in this example is written directly without any apostrophes as: 20090701T000000Z
using <ISO datetime>
format, you can also use another format: 2009-07-01