DSXchange

Posted: **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.

Posted: **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?

Posted: **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?

Posted: **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?

DSXchange

Timestamp issue in ODBC stage of Vertica Database

Timestamp issue in ODBC stage of Vertica Database