IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need help to fetch timestamp field having old format.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
bhamarekm

New User


Joined: 20 Sep 2010
Posts: 9
Location: Pune

PostPosted: Wed Oct 22, 2014 1:22 am
Reply with quote

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
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Wed Oct 22, 2014 2:05 am
Reply with quote

TIMESTAMPs are not stored with any punctuation in DB2 tables!
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2588
Location: NYC,USA

PostPosted: Wed Oct 22, 2014 3:59 am
Reply with quote

Use LOCATE as required.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Printing a dataset in DUMP format wit... ABENDS & Debugging 2
No new posts Calculate with timestamp PL/I & Assembler 19
No new posts Converting a file from PD to display ... SYNCSORT 4
This topic is locked: you cannot edit posts or make replies. Passing a field name to COBOL program COBOL Programming 10
No new posts Date format conversion DFSORT/ICETOOL 4
Search our Forums:

Back to Top