Skip to Content

Decimal(19,0) to Datetime column conversion

Feb 16 at 01:48 PM


avatar image

Hi All,

Do we have to explicitly specify any format specific to HANA datetime for converting a decimal column in SQL server(Source) to Datetime column in HANA(Target)

I placed a temporary table in SQL server and was able to convert the decimal value to datetime

Source Column Data:



Target Column in SQL Server Table

2017.10.05 15:37:31.000000000

But when I try to use to_date function for HANA column mapping it doesnt work

Any inputs would be appreciated with karma points


Arun Sasi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dirk Venken
Feb 19 at 05:36 PM

What's the generated SQL code in both cases? Is the SQL pushed down to the database?

That will all make a difference. An implicit conversion will always be done, if you don't explicitly specify the format. So you may be lucky, you may be not.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Dirk!!

The below conversion works fine to_date(cast(AUDIT_START_TIME,'varchar(24)'), 'YYYYMMDDHH24MISS')

If we simply do the below conversion, it will print NULL as HANA does not understand the character conversion, therefore we have to cast it as varchar(24).


In both the cases DS generates does not add any conversion function (SQL in Validate SQL) for the Audit Start Time and Audit End Time columns


Arun Sasi