In Rational Developer for I Database perspective, change timestamp format

Question

I'm used to working with timestamp format '2020-09-12-09.00.00.00000', for example.

I discovered, after a lot of trial and error, that I need to input '2020-09-12 09:00:00.000000' to achieve the same goal when using Rational Developer for i. Is there a way to change that?

I don't need to do that when working directly on the emulator (using strsql)

Answer 1

That is a JDBC thing. You need to change the driver property "timestamp format" to ibmsql vs. iso.