MSSQL and TIMESTAMP WITH TIME ZONE

Hello one more time.

As I have said early, MSSQL processes TIMESTAMP WITH TIME ZONE datatype using DBTIMESTAMPOFFSET structure OLE DB.

Today I have checked it again. It is so really.

By default IBProvider publishes TIMESTAMP WITH TIME ZONE as text but you can change this behavior using dbtimestamp_with_tz_rules property. That I did in this case — I defined this property in connection string with «1» value.

PS. I think, it is the first time when MSSQL connect to FB4. Although, maybe, one of our clients have already done it 🙂

Leave a Comment