Skip to Content
0
Former Member
Jun 04, 2013 at 09:07 AM

how to cast hexdecimal to timestamp

191 Views

HI,

We are recently migrating from SQL server to HANA.

The generated SQL script has a date column which has the value as "CAST(0x0000A15601305A74 AS timestamp)".

When i'm trying to execute this script in SQL Editor in HANA Studio, it throws me an error which says "[303]: invalid DATE, TIME or TIMESTAMP value: Error while parsing DATE/TIME at function to_timestamp()".

any help will be appreciated.

Regards

Prashanth Polasa