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

Get correct date and time when current time is over 12 hrs


IBM Mainframe Forums -> DB2
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
balaji81_k

Active User


Joined: 29 Jun 2005
Posts: 155

PostPosted: Wed Oct 19, 2016 9:20 pm
Reply with quote

Hi Rahul,

Sorry it is missing in the post , actual query has the case statement .
I break each field and even tried to cast the col2 as CHAR(2) but couldn't able to avoid the low value in the output file icon_cry.gif
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Wed Oct 19, 2016 9:25 pm
Reply with quote

Why not cut and paste the real query - then people will be working with reality instead of something that is, basically, a figment of the imagination.

And, how do you know it is a low-value? All you have presented is a plain-text impression - not the 'hex on' view. Without that we do not know if it is a real period, a low value or some other unprintable value.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Oct 19, 2016 9:57 pm
Reply with quote

time to lock the topic, it is going nowhere
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


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

PostPosted: Wed Oct 19, 2016 11:01 pm
Reply with quote

I think, we should lock this topic and let the TS open a new one with right and complete query instead of piece meal.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Oct 19, 2016 11:32 pm
Reply with quote

done
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts To get the the current time DFSORT/ICETOOL 13
No new posts RC query -Time column CA Products 3
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts Validating record count of a file is ... DFSORT/ICETOOL 13
Search our Forums:

Back to Top