snowflake-cloud-data-platformdatetime-format

Oracle database timestamp(6) when converting to snowflake timestamp_ntz throws error

I have a data in the source system, which looks like the following:

"02-FEB-10 05.25.21.367709000 AM"

But when i try to convert the data into snowflake by using timestamp_ntz it throws

failed to cast variant error

As per the Documentation and compatibility it suggests timestamp can do the work but it doesn't. https://docs.snowflake.com/en/sql-reference/data-types-datetime.html

How to solve this issue?

Solution

  • This is just a format parsing issue. Here's a parse string that works:

    select try_to_timestamp_ntz('02-FEB-10 05.25.21.367709000 AM', 'DD-MON-YY HH.MI.SS.FF AM');