db2 design advisor giving error SQL0180N The syntax of stringrepresentation of a datetime value is incorrect

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • db2admin

    db2 design advisor giving error SQL0180N The syntax of stringrepresentation of a datetime value is incorrect

    hello,

    i am using v9.1.0.4 FP4 and run into issues when i try to run design
    adviser from control center. even with simple SQL like select * from
    table, I get error SQL0180N The syntax of string representation of a
    datetime value is incorrect
    please share if someone has encountered this error before and what
    could be the issue and resolution.

    regards,

    db2admin
Working...