on 05-10-2015 12:49 PM
Dear Hana Gurus,
My Scenario : Loading data to HANA from BODS.
I've checked the date format in excel and everything is fine.
Not sure if there's any hidden conversion routine in the HANA which is converting the current year to 1915 (going back 100 years )
Any helps is highly appreciated.
Regards,
-Baseer
While inserting Flat file data have you used some date conversion functions?
Like todate or tochar?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sawpnil,
Thanks , yes this is bug exist in To_Date & To_Char, please refer to the following SAP NOTE : 2134992
http://service.sap.com/sap/support/notes/2134992
Appreciate your help.
Regards,
-Baseer
The Data Services function to_date with YEAR value 2015 generates an incorrect result; for example, to_date('01-JAN-15','DD-MON-YY') returns as 01/02/1915 (wrong century).
Other Terms
Environment:
This affects all SAP Data Services versions.
This issue is tracked in Corrective Measure 4912 2015.
Reason and Prerequisites
This issue occurs because of a programming error.
Solution
Workaround
As a workaround, perform the following steps:
OR
If the job server is Windows, in the Designer, select Tools > Options > Data > General and change Century Change Year to 99.
This affects years such as 1999. All 20th century years are fine.
YY as 99 will be 1999.
YY as 15 will be 2015.
3. Test all clients to verify that they pick up the change on the job server that they are associated with via the local repository.
Fix
This correction is delivered in the release(s) listed in the Support Packages and Patches section of this SAP Note.
User | Count |
---|---|
89 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.