Saving date with time zone

[smelchi]

Hi using Delphi XE, UNIDAC 6.01, SQL SERVER 2008 how can I save and retrieve datetime with time zone in datetimeoffset field?

Thanks

[azyk]

You can work with the datetimeoffset data type as with a string value in the following format:

Code: Select all

YYYY-MM-DD hh:mm:ss[.nnnnnnn] [+|-]hh:mm

For this, set the 'OLEDBProvider' option to 'prSQL' in the connection settings. For example:

Code: Select all

UniConnection.SpecificOptions.Values['OLEDBProvider'] := 'prSQL';