Skip to Content
0
Jun 19, 2020 at 01:14 PM

Date format in HANA.

597 Views Last edit Jun 19, 2020 at 01:14 PM 2 rev

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.