I have to delete from db2 table where db2 timestamp column is defined as 26,6 and its value is as follows:
2008-09-03 13:42:10.333
While extracting from the db2 table and passing to a dataset, same timestamp column is giving value as follows:
2008-09-03 13:42:10
When i try to delete from the table with above key its not matching and doesnt delete rows. Any suggestion.
DB2 Timestamp Matching
Moderators: chulett, rschirm, roy
DB2 Timestamp Matching
Last edited by ds2000 on Tue Sep 09, 2008 2:54 am, edited 1 time in total.
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: