Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Need help to fetch timestamp field having old format.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Need help to fetch timestamp field having old format.
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    Post subject: Reply to: Need help to fetch timestamp field having old form
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

Senior Member


Joined: 21 Sep 2010
Posts: 2105
Location: NY,USA

PostPosted: Wed Oct 22, 2014 3:59 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Regression testing of date format con... prino CLIST & REXX 0 Fri Jan 11, 2019 5:39 am
No new posts DB2 Timestamp field weird behaviour. rizwanaccy DB2 7 Wed Dec 26, 2018 4:33 pm
No new posts Fetch first first row in inner join! Vignesh Sid DB2 13 Tue Dec 04, 2018 7:25 pm
No new posts Code numeric format to display both '... Time2Live COBOL Programming 7 Wed Nov 21, 2018 10:20 pm
No new posts DB2 SQL Query to fetch all instances ... MallikarjunSM DB2 2 Thu Sep 27, 2018 6:46 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us