Date Conversion from YYYYDDD to YYYYMMDD format

mrdinesh · New User Joined: 23 Sep 2006 Posts: 24 Location: India

Is there any way in DFSORT to convert Dates. In my case I receive an Input file with the dates yyyyddd format and I would need to convert it to yyyymmdd format. The input file is received in the text format.

Input File:

karthick1990 · New User Joined: 12 Jun 2014 Posts: 4 Location: India

Yes.

I have option to test for syncsort only, here is the equivalent in syncsort.

Bill Woodger · Posted: Mon Jan 18, 2016 3:41 am

mrdinesh

The DFSORT manuals cover date data-types and date functions. If you just ask, instead of trying to find out for yourself, and asking if unsure, you'll never learn how to find anything out.

karthick1990

Two-digit years haven't been used since last century. Why do that, when you have a four-digit year?

steve-myers · Posted: Mon Jan 18, 2016 4:41 am

karthick1990

Just to add to Mr. Woodger's comment. Part of the Y2K business from 20 odd years ago was the use of two digit dates. One would have thought that no analyst in their right mind would authorize the use of a 2 digit date except, perhaps, for display purposes. But I see this creeping back into our trade now.

Now I see the year 2100 as being worse than 2000 if us analysts persist in being lazy. 2000, at least, was a leap year. 2100 is not a leap year in the Gregorian calendar, so we will have that issue to deal with in addition to the same date comparison issue that bedeviled us in 2000. Now I grant few people reading this forum will have to deal with 2100 issues 80 some years from now, but if us analysts don't get smart NOW our children, grandchildren and great grandchildren are just going to repeat the Y2K problem all over again.

Part of what brings this to mind is, as I'm writing this, I'm working on a program that takes, in its input, 2 digit years. The data area containing the 2 digit year was designed around 1970, but that's a poor excuse. I can make the program Y2K compatible, but because of the crappy input, I cannot make the program Y2K compliant, much less Y21K capable.

karthick1990 · New User Joined: 12 Jun 2014 Posts: 4 Location: India

Bill Woodger/Steve-myers,

Seeing the OP's data sample allowing date process here to go on with CENTWIN option to calculate century
is not Good in all the case. yep, with 4 digit year processing things would be better for centuries.

boyti ko · New User Joined: 03 Nov 2014 Posts: 78 Location: Malaysia

Just want to share my experience, in my site previously, I saw the same. Something like this.

mrdinesh · New User Joined: 23 Sep 2006 Posts: 24 Location: India

Thanks Bill. I was able to convert the Julian date to the desired format.

PeterHolland · Posted: Tue Jan 19, 2016 2:56 pm

Bill Woodger

Bill Woodger · Posted: Tue Jan 19, 2016 3:56 pm

And DFSORT has date formats for SMF dates (and time formats for SMF times).

If you want to consider a two-digit year with a century indicator the same as a two-digit year, fair enough. I was just being humorous. There are two-digit years out there, but there's no need to treat a four-digit year as a two-digit year was the point I was getting at.