Timestamp issue in ODBC stage of Vertica Database

shankararunn · Post by **shankararunn** » Tue Apr 19, 2016 5:18 pm

In input i am receiving the timestamp as 2016-04-05-19.23.38.453000 in string format and need to convert it to timestamp as 2016-04-05 19:23:38.453000. I used timestamp from string function in transformer, but its failing in the insert saying " ODBC Info: SQLSTATE = 22008: Native Error Code = 40,520: Msg = [Vertica][Support] (40520) Datetime field overflow resulting from invalid datetime " . Please help.

chulett · Post by **chulett** » Tue Apr 19, 2016 8:42 pm

Once again, splitting you off from a vaguely related topic to one of your own. Maybe just start with a new one next time.

Can you show us the syntax of the function you used in your job?

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Wed Apr 20, 2016 8:48 am

Also - can you try outputting the timestamp to the director log using a Peek to see what is being output?

ray.wurlod · Post by **ray.wurlod** » Wed Apr 20, 2016 2:55 pm

There is no need to ask the question via Private Message unless you are seeking to engage services on a professional basis.

What format string are you using with the TimestampFromString() function?