Micro Focus Visual COBOL 2.3 for Visual Studio 2015 > Programming > Data Access > Database Access > Reference > SQL Data Types > Date and Time Data Types > TIMESTAMPOFFSET

TIMESTAMPOFFSET

Data Format

If a COBOL output host variable is defined for an SQL timestamp value with an offset, the date and time are specified in the following format:

yyyy-mm-dd hh:mm:ss[.f[f[...]]]  {+ | -}hh:mm

where the number of fractional digits is driver-defined. For example:

1994-05-24 12:34:00.000 +02:00

Host Variable Formats

OpenESQL and DB2 ECM

01 timestampoffset1   PIC X(36).

OpenESQL

01 timestampoffset2   SQL TYPE IS TIMESTAMP-OFFSET.
01 timestampoffset3   SQL TYPE IS TIMESTAMP-OFFSET-RECORD.

The timestampoffset2 format uses the TIMESTAMP-OFFSET SQL TYPE.
The timestampoffset3 format uses the TIMESTAMP-OFFSET-RECORD SQL TYPE.

OpenESQL .NET Managed Runtime

In addition to the definitions valid for all databases and those valid for OpenESQL, the following definition is also valid for the OpenESQL .NET Managed Runtime:

01 timestampoffset4   type System.DateTimeOffset.