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
 
Julian(YYDDD) to CCYY/MM/DDconversion

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Shanu.sukoor

New User


Joined: 31 Jan 2006
Posts: 32
Location: India

PostPosted: Wed Feb 14, 2007 11:21 am    Post subject: Julian(YYDDD) to CCYY/MM/DDconversion
Reply with quote

Hi,

I have to write a query to fetch data. But one of the input date values is in julian format - YYDDD. I have to convert into DB2 compatible form CCYY/MM/DD. Is there any function available in DB2 to do that.

Input value is in a host variable. Writing a logic to convert using cobol would take long time.

Please post your replies. Thank you.

Shanu S Sukoor
Back to top
View user's profile Send private message

vijikesavan

Active User


Joined: 04 Oct 2006
Posts: 118
Location: NJ, USA

PostPosted: Thu Feb 15, 2007 11:46 pm    Post subject: Re: Julian(YYDDD) to CCYY/MM/DDconversion
Reply with quote

I am not sure something like that exists. With my little knowledge I tried googling..but couldnot find any answers..
Will be interested to see if you cracked out something. Pls share if you do so.

Thanks,
Viji
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Fri Feb 16, 2007 12:10 am    Post subject: Re: Julian(YYDDD) to CCYY/MM/DDconversion
Reply with quote

Shanu.sukoor wrote:
Input value is in a host variable. Writing a logic to convert using cobol would take long time.
With intrinsic functions, the convert could be done in one statement.
Back to top
View user's profile Send private message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Mon Feb 19, 2007 12:35 pm    Post subject:
Reply with quote

I believe during installation whatever the date format is set that particular format can be retrived/used.

I think as william said intrinsic functions can be used for this...

Regards,
jr
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 Julian Date to CICS ABSTTIME blayek CICS 3 Wed Aug 30, 2017 11:15 pm
No new posts HEADER1 and TRAILER1 with Julian date... nileshinus DFSORT/ICETOOL 3 Mon Oct 13, 2014 10:45 pm
No new posts SORT to add (replace) date in Julian ... zh_lad DFSORT/ICETOOL 8 Mon May 12, 2014 2:25 pm
No new posts Julian date to Gregarian date using ... sudhakar_mainframe DFSORT/ICETOOL 2 Tue Oct 15, 2013 6:12 pm
No new posts write particular julian date of the m... Skolusu DFSORT/ICETOOL 2 Mon Jan 23, 2012 2:12 am

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