search

BuzzCutNorman / tap-mssql

Singer Tap for MS SQL built with Meltano Singer SDK.
MIT License
2 stars 9 forks source link

feat: Support for `datetimeoffset` data type #31

Open BuzzCutNorman opened 1 year ago

BuzzCutNorman commented 1 year ago

Defines a date that is combined with a time of a day based on a 24-hour clock like datetime2, and adds time zone awareness based on UTC (Universal Time Coordinate or Greenwich Mean Time).

https://learn.microsoft.com/en-us/sql/t-sql/data-types/datetimeoffset-transact-sql?view=sql-server-ver16

https://docs.sqlalchemy.org/en/14/dialects/mssql.html#sqlalchemy.dialects.mssql.DATETIMEOFFSET

BuzzCutNorman commented 1 year ago

After doing some research I think this is actually the built in JSON Schema string format of "date-time" "format": "date-time"