DB2 Timestamp Matching

ds2000 · Post by **ds2000** » Mon Sep 08, 2008 3:16 pm

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.

ds_developer · Post by **ds_developer** » Mon Sep 08, 2008 3:52 pm

DB2 has somewhat of an odd default timestamp format (if you are more from an Oracle background). It is yyyy-mm-dd-hh24.mi.ss.nnnnnn

Notice the hyphen between the day and hour, and the decimal points between the minutes, second and milliseconds. Try using a timestamp in this format if you can.

John

ray.wurlod · Post by **ray.wurlod** » Mon Sep 08, 2008 3:56 pm

Server job (as marked) or parallel job (as posted)?