Search code examples
ibm-midrangedb2-400ibm-rational

In Rational Developer for I Database perspective, change timestamp format

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)

Solution

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