|
View previous topic :: View next topic
|
| Author |
Message |
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. |
|
| Back to top |
|
 |
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| TIMESTAMPs are not stored with any punctuation in DB2 tables! |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
| Use LOCATE as required. |
|
| Back to top |
|
|
|
|
