|
View previous topic :: View next topic
|
| Author |
Message |
Shanu.sukoor
New User
.jpg)
Joined: 31 Jan 2006
Posts: 32
Location: India
|
|
|
|
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 |
|
 |
vijikesavan
Active User
Joined: 04 Oct 2006
Posts: 118
Location: NJ, USA
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| 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 |
|
|
rajandhla
Active User
.jpg)
Joined: 18 Oct 2005
Posts: 182
Location: Luton UK
|
|
|
|
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 |
|
|
|
|
