Using datetime2 with Informatica

coursedrill · October 13, 2021, 6:31am

I have the requirement for dates that predate 1753, the minimum for datetime on SQL Server. DB-side, the solution is clear: change to datetime2 format. But it seems Informatica still treats the column as datetime. I suppose datetime2 is not supported. Is there any workaround that could enable me to insert pr-1753 dates in a datetime2 column?

Informatica version is 9.1.0, SQL Server 2008

dorian_yugabyte · October 13, 2021, 6:32am

Hi @coursedrill

YugabyteDB supports PostgreSQL 11.2 api, which supports datetimes up to 4713 BC.

Topic		Replies	Views
Is there a way to get “updated_at” timestamps from YCQL without additional columns? General	1	600	August 11, 2020
Issue:Snapshot too old General	7	2124	January 20, 2020
Import Postgresql database General	4	1088	July 7, 2020
More than 100 fields as IN parameter is not permitted -- cannot map Yugabyte UDT, used as a parameter of a function, from Java General	1	355	November 6, 2023
Invalid argument: Read time should NOT be specified for serializable isolation level General	4	697	November 10, 2022

Using datetime2 with Informatica

Related Topics