Hi ,
I m facing one funny problem .

We had developed an application using db2 version-8.0
When we deployed the application in Production which uses db2 verion 7.0, it failed .

The reason was the delimiter character used for TimeStamp used in queries.

For db2-8.0 the delim char is - :
And for 7.0 the delim char is - .

Please help me to fix the issue.

The issue is related to TimeStamp only.
I may be wrong that the issue may not be related to delim char.

Please help me out .. U r suggestion for better design are welcome

can the bind command and datetime option not help ?
check the formats supported by bind usa-eur-iso....

Guy, Does the date formats depend on database locale settings - TERRITORY, CODEPAGE, REGION etc. ?

Sathyaram