SQL Server 2008 introduced a new SQL date/time data type, DATETIMEOFFSET, which is supported by OpenESQL. The date and time are specified in the following format:
yyyy-mm-dd hh:mm:ss[.f[f[...]]] {+ | -}hh:mm
Host Variable Formats
OpenESQL
01 datetimeoffset1 PIC X(34).
This data type can also use a DateTimeOffset record layout. For more information, see the topic
The SQLDA Data Structure.