IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Date Conversion Y2T to Y2W


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
yuvan

New User


Joined: 10 Jan 2006
Posts: 23
Location: India

PostPosted: Wed Dec 02, 2020 11:51 am
Reply with quote

Hi Team,

I am trying to convert a date in format yymmdd to mmddyy and could do successfully for all dattes except the date 000229 (200 -Feb-29), it is failing and converted as 999999 .

I am using below format

Y2T to Y2W

Could you please me if any thing needs to be added for the above date conversion .



Thanks
yuvan
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2453
Location: Hampshire, UK

PostPosted: Wed Dec 02, 2020 5:03 pm
Reply with quote

Please post an exact record that has failed this conversion, your full control cards and messages.
Back to top
View user's profile Send private message
sergeyken

Active Member


Joined: 29 Apr 2008
Posts: 930
Location: Maryland

PostPosted: Wed Dec 02, 2020 8:24 pm
Reply with quote

yuvan wrote:
Hi Team,

I am trying to convert a date in format yymmdd to mmddyy and could do successfully for all dattes except the date 000229 (200 -Feb-29), it is failing and converted as 999999 .

I am using below format

Y2T to Y2W

Could you please me if any thing needs to be added for the above date conversion .



Thanks
yuvan

It is a very bad habit, to make people guessing what your actual code/input/output/messages are, without giving us clear information. icon_axe.gif

I only can guess that your CENTWIN option (either default, or explicit) makes SORT to consider year 00 as 2100, rather than 2000. That’s why your date 000229 is considered as 2100/02/29, which is wrong value, and replaced with 999999.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2571
Location: NYC,USA

PostPosted: Wed Dec 02, 2020 10:33 pm
Reply with quote

You can raise a ticket with syncsort, if Manual says it should work.
To solve the problem , you can always reformat yymmdd to mmddyy and get going. Or you can convert yymmdd to yyyymmdd and then convert to mmddyyyy and then to mmddyy.
Back to top
View user's profile Send private message
Joerg.Findeisen

Active User


Joined: 15 Aug 2015
Posts: 388
Location: Bamberg, Germany

PostPosted: Wed Dec 02, 2020 10:50 pm
Reply with quote

Sergeyken's assumption seems valid. The SYSOUT should list something like this for the given date:
Code:
WER490I  INVALID DATE ENCOUNTERED IN DATE FORMAT ARITHMETIC OR CONVERSION
WER448I  Y2 FORMAT CENTURY WINDOW IS FROM 2020 TO 2119                   

It can be fixed by specifying a sliding window for ex.
Back to top
View user's profile Send private message
sergeyken

Active Member


Joined: 29 Apr 2008
Posts: 930
Location: Maryland

PostPosted: Thu Dec 03, 2020 1:59 am
Reply with quote

The YEAR2000 nightmare is on its way!
358.gif 36_11_6.gif 12.gif
Back to top
View user's profile Send private message
Joerg.Findeisen

Active User


Joined: 15 Aug 2015
Posts: 388
Location: Bamberg, Germany

PostPosted: Thu Dec 03, 2020 2:59 am
Reply with quote

..and the next Y10K problem is already waiting. icon_eek.gif
Back to top
View user's profile Send private message
sergeyken

Active Member


Joined: 29 Apr 2008
Posts: 930
Location: Maryland

PostPosted: Thu Dec 03, 2020 7:40 pm
Reply with quote

Joerg.Findeisen wrote:
..and the next Y10K problem is already waiting. icon_eek.gif

A Top Secret info.

Prior to expected Y10K problem there are three extra planned, but less known problems: the years 3200, 6400, and 9600 are supposed to be non-leap years, despite of leap-rules based on division by 4, by 100, and by 400. 358.gif 2014.gif 36_11_6.gif
Back to top
View user's profile Send private message
prino
Warnings : 1

Senior Member


Joined: 07 Feb 2009
Posts: 1239
Location: Vilnius, Lithuania

PostPosted: Thu Dec 03, 2020 9:05 pm
Reply with quote

The first is actually 2030, as a hell of a lot of windows used to alleviate Y2K are from 1930 to 2029. When done in a sensible way, it will mean recompiling one or two modules. When not...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Date conversion using SORT SYNCSORT 4
This topic is locked: you cannot edit posts or make replies. Write Character to Hexadecimal file w... COBOL Programming 8
No new posts Date format conversion DFSORT/ICETOOL 4
No new posts Hex Value - vb file replace old date ... DFSORT/ICETOOL 14
No new posts EBCDIC to ASCII conversion help All Other Mainframe Topics 1
Search our Forums:

Back to Top