When running a script, when selecting the inserted data, the timestamp columns in the as400 driver are not converted correctly. For example, when inserting:
INSERT INTO Test (ID, FEC) VALUES ('10', '2020-06-01 01:23:45');
And then do the select:
SELECT * FROM Test WHERE (
trim(ID) = '10'
AND trim(FEC) = '2020-06-01 01:23:45'
);
But it should be:
SELECT * FROM Test WHERE (
trim(ID) = '10'
AND FEC = timestamp '2020-06-01 01:23:45'
);
When running a script, when selecting the inserted data, the timestamp columns in the as400 driver are not converted correctly. For example, when inserting:
And then do the select:
But it should be: