I am using IDAA for DB2. At one point I use TO\_DATE to convert some dates and it works:

`TO_DATE('09/03/2018 06:49:23','MM/DD/YYYY HH:MI:SS')`

But when I have a VARCHAR value with milliseconds in the timestamp, TO\_DATE returns an error. I looked around online and found an answer that says to use TO\_TIMESTAMP but that doesn't work:

`TO_TIMESTAMP('09/03/2018 06:49:23.443000','MM/DD/YYYY HH:MI:SS.NNNNNN')`

I've looked at every answer on here and tried many variations. I've tried every combination of the functions TO\_TIMESTAMP, TO\_DATE, TIMESTAMP\_FORMAT and the format for milliseconds as FF, FF6, NNNNNN. I get these errors:

`NO AUTHORIZED FUNCTION NAMED TO_TIMESTAMP HAVING COMPATIBLE ARGUMENTS WAS FOUND. SQLCODE=-440`

`SQL error: SQLCODE = -904, SQLSTATE = 57011, SQLERRMC = Invalid Date.. SQLCODE=-904`

Maybe it's different for the IDAA? I don't know.

I'm running DB2 for z/OS V11 using IBM Data Studio 4.1.3.