Hi All, As a part of migrating from Oracle db to HANA db,I aM evaluating database functions in Oracle vs HANA. The date in oracle is
as follows: '5/6/2020 9:27:38 AM' .
We have loaded this column into HANA DB using BODS ETL tool without any modification from the source table (i.e Oracle). When loaded in HANA this column is appearing
as follows:May 6, 2020 9:27:38.0 AM. The date type present in HANA for this column is LONGDATE.
The requirement is to get the date same as the format in ORACLE. Please help me on this.