TSTAMPSEP

Specifies a single character as the separator between the date and time parts of timestamp and date/time data.

Syntax

TSTAMPSEP=character

Properties:

Default:

None

Scope:

Used at compile time:	Yes
Behavior at run time:	Source file

See Scope - OpenESQL SQL Compiler Directive Options for more information.

Comments:

When using TSTAMPSEP with the HCOSS DIALECT directive, the DIALECT directive setting determines the output format for timestamp and date/time data, and each data format uses a specific separator character. TSTAMPSEP overrides the separator character used by default in each data type.

See Date and Time Data Types for more information.