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

  • Interview Candidate
  • 2
  • 2691

Showing Answers 1 - 2 of 2 Answers

Sitaram Yarlagadda

  • Nov 23rd, 2005
 

Use Sysdate or use to_date for the current date

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions