In a filter expression we want to compare one date field with a db2 system field CURRENT DATE.Our Syntax: datefield = CURRENT DATE (we didn't define it by ports, its a system field ), but this is not valid (PMParser: Missing Operator)..Can someone help us. Thanks

Sitaram Yarlagadda

• Nov 23rd, 2005

 

Use Sysdate or use to_date for the current date

gazulas

 Profile Answers by gazulas Questions by gazulas

• Jan 29th, 2006

 

the db2 date formate is  "yyyymmdd"  where as sysdate in oracle will give "dd-mm-yy" so conversion of db2 date formate to local database date formate is compulsary. other wise u will get that type of error