# Using datetime2 with Informatica

**URL:** <https://forum.yugabyte.com/t/using-datetime2-with-informatica/1238>\
**Category:** General\
**Created:** [October 13, 2021, 6:31am UTC](https://forum.yugabyte.com/t/using-datetime2-with-informatica/1238 "2021-10-13T06:31:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![coursedrill](https://avatars.discourse-cdn.com/v4/letter/c/cdc98d/32.png) [@coursedrill](https://forum.yugabyte.com/u/coursedrill)\
**Post date:** [October 13, 2021, 6:31am UTC](https://forum.yugabyte.com/t/using-datetime2-with-informatica/1238/1 "2021-10-13T06:31:10Z")

</div>

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](https://coursedrill.com/informatica-cloud-training/) 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

---

<div class="post-metadata">

**Author:** ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)\
**Post date:** [October 13, 2021, 6:32am UTC](https://forum.yugabyte.com/t/using-datetime2-with-informatica/1238/2 "2021-10-13T06:32:45Z")

</div>

Hi @coursedrill

YugabyteDB supports PostgreSQL 11.2 api, which supports [datetimes up to 4713 BC](https://www.postgresql.org/docs/11/datatype-datetime.html).