$usetimezone with ODBC DAM and SQL Server

[Thad Bogert]

Hi All,

Has anyone had the opportunity to use the timezone conversion properties in the ODBC DAM?

I am curious about how effective it has been.

The current documentation for the feature is a bit sparse. It just states the following:

If kTrue, $timezone will be applied to values inserted and fetched from TIME & TIMESTAMP columns, that is; datetime values are subject to modification by comparing the local timezone with the server’s timezone. Applies to MS-SQL Server connections only.

If it truly converts all time and timestamp values going in and out, it will save us considerable time for readying our application for use in multiple timezones. 


Thanks,

Thad