View previous topic :: View next topic
|
Author |
Message |
sunilmvs
New User
Joined: 29 Oct 2006 Posts: 1
|
|
|
|
I had a very unusal scenario. We had a date comparison logic in our program in which we compared the current date with the date in the db2 table. In the comparison we copied the current date in the signed numeric field and the table date in alphanumeric field. The logic was if the current date > table date then a flag has to be set.
In the testing it worked fine , but when we moved the code to the production it failed can you explain the reason for this. |
|
Back to top |
|
|
UmeySan
Active Member
Joined: 22 Aug 2006 Posts: 771 Location: Germany
|
|
|
|
Hi !
The reason could depend on different aate formats between test and
produktion environment or simply that your testing dates fits the comarison and in produktion not.
For a correct date comparison coded yourself, the both dates must have format JJJJMMTT. So transform bothe dates to that format and then code you IF-Comparison.
Regards, Umeysan |
|
Back to top |
|
|
|