MVSFORUMS.com

shekar123

Hai All,

I have a requirement which says to convert the julian date to a date readable in the format mm-dd-ccyy for a report.How can be this done and i do not know any thing about Julian dates .Why do we use Julian dates when we have DB2 date facility.Can anybody help me out in this requirement and any sample example showing the real usage of Julian date and how to convert julian date to the date format would really be helpful.

Is there any particular significance of using Julian date when we have inbuilt DB2 date functions available ?
_________________
Shekar
Grow Technically

kolusu · Posted: Wed Mar 22, 2006 4:17 pm Post subject:

shekar123,

Please search before posting. check this link which explains in detail about julian dates evaluation and their usage

http://www.mvsforums.com/helpboards/viewtopic.php?t=4195&highlight=julian

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

shekar123 · Posted: Wed Mar 22, 2006 9:49 pm Post subject:

Koulsu,

Thanks for the link provided and it has a very good information of Julian dates.Can i have a small sample example to convert the Julian date to a date in the format mm-dd-ccyy as it would really help me out in understanding.
_________________
Shekar
Grow Technically

kolusu · 2006-03-23

shekar123,

simple the julian date equivalent of march 23rd 2006 is

2006082

where 2006 is the current year and 082 is the day of the year

shekar123 · Posted: Thu Mar 23, 2006 7:25 am Post subject:

Kolusu,

Thanks for your reply and i now clear with the example provided by you.I have a requirement where i have to convert julian date to yyyy-mm-dd format.

Julain start date as PIC X(05) value is '03/05'.
Julian end date as PIC X(05) value is '/0407'.

I am assuming the values in yyyy-mm-dd format to be as below.Please correct me if i am wrong.

03/05 -------------------- 2003-01-05
/0407 -------------------- 2004-01-07
_________________
Shekar
Grow Technically

kolusu · Posted: Thu Mar 23, 2006 7:52 am Post subject:

shekar123 · Posted: Fri Mar 24, 2006 5:19 am Post subject:

Hai Kolusu,

Thanks for making me clear in my understanding and Is there any function available which converts the julian date to a db2 date format as i need to convert the Julian date into db2 date in my program and make use of it further ahead ?
To incorporate this , if we do not have any fucntion avaiable , what would be logic be to convert julian Date to DB2 date.
_________________
Shekar
Grow Technically

kolusu · Posted: Fri Mar 24, 2006 7:01 am Post subject: