conversion of julian date of format 'yyyyjjj' to date

[syam]

Hi All,

I want to convert the date format of the type 'yyyyjjj' ex:2006346 to date. and i am trying to do it by using the julianday to date function. but it's not working . The format of the output date is 'yyyy/mm/dd'. how to convert this .
Any help is appreciated.

syam.

[boppanakrishna]

hi syam ,
use stringto datefunction,,

syntax:
stringtodate(i/pstring[1,4]:"/":i/pstring[5,2]:"/":ipstring[7,2],"%yyyy/%mm/%dd")

try using the above function hope this helps you

[syam]

WHAT I WANT IS CONVERSION OF JULIAN DATE TO DATE. HOW ICAN DO THIS BY USING STRING TO DATE. HOW TO CONVERT THE 2006346 TO DATE0F TYPE EG:2006/12/12 . WHAT IS THE FUNCTION USED FOR THIS CONVERSION. ANY WAYTHANKS FOR YOUR REPLY.

[battaliou]

There's probably some other cool Julian date functions out there, but here's a quick solution:

dj = '2006346'
oconv(iconv(dj[1,4]:'/01/01','d/ymd[4,2,2]') + dj[5,3],'d/ymd[4,2,2]')

This simply adds internal days at 1st January 2006 plus julian days since (346) and outputs in the format d/ymd[4,2,2].

If you need this to run in enterprise edition, you will have to use a string to decimal conversion on the substring dj[5,3], probably best done by way of a stage variable.

[srinath]

I think the julian date format will be CYYJJJ and the data will be like
dj = 106346

to convert the above one we can use this OCONV(ICONV(dj + 1900000,"D2/"),"D4/MDY").

You can use some other date formats for the above one to get the desired result.

[DSguru2B]

You have posted in a px forum and marked the job type as server, which one is it?

[syam]

the job type is parallel . and mentioned the same in the question also.

[BalageBaju]

Sayam,

But you posted in Server Edition forum.
Plz mention your correct input format whether is it 2006346 or 106346 as per Srinaths post. I think the correct Julian day format is 106346.
Plz try with the function
"DateFromJulianDay"

Hope this will help you...

[DSguru2B]

Search. This has been covered before. Like here.

[Apotluri]

Hi All,

I want to convert the date format of the type 'yyyyjjj' ex:2006346 to date. and i am trying to do it by using the julianday to date function. but it's not working . The format of the output date is 'yyyy/mm/dd'. how to convert this .
Any help is appreciated.

syam.

Hi Syam,

Actually, the data you are getting is not Julian date, it is Ordinal date.
If it is a parallel job, use 'basic transformer' and try with
Oconv(Iconv(link.fieldname,"DYJ"), "D-YMD[4,2,2]"):' 00:00:00'

-APotluri

[ray.wurlod]

In a server job,

Code: Select all

Oconv(Iconv(InLink.TheDate, "DYJ"), "D/YMD[4,2,2]")

In a parallel job you could use this expression in a BASIC Transformer stage, if you didn't mind the performance penalty.

Otherwise you will need to use parallel job functions. Why not start a new thread on the parallel forum?