Need help to fetch timestamp field having old format.

bhamarekm · New User Joined: 20 Sep 2010 Posts: 9 Location: Pune

Hi Team,

I need small help. Till DB2 10 version while inserting data in field having type as TIMESTMP we were able to insert data like 2011-01-13-11:31:25.266212.
BUt when we browse table using DB2 for fileaid or BMCADM DB2 automatically converts data from 2011-01-13-11:31:25.266212 to 2011-01-13-11.31.25.266212 while displaying.

I need to find out in column xxx how many rows in table aaa.bbbb having ":" in between hh and mm and mm and SS.

Thanks for help in advance.

Craq Giegerich

TIMESTAMPs are not stored with any punctuation in DB2 tables!

Rohit Umarjikar · Posted: Wed Oct 22, 2014 3:59 am Post subject:

Use LOCATE as required.