SQL Operations Guide

SETENV TPE_DFLT_DATE

Changes the default date format used by FairCom DB SQL. Changing the default date format affects:

• The default output format of date values;
• How SQL interprets date literals in queries and INSERT statements.

The following date types are supported:

• US - US_DFLT_DATE
• UK - UK_DFLT_DATE
• ISO - ISO_DFLT_DATE

Examples

SETENV TPE_DFLT_DATE=UK

SETENV TPE_DFLT_DATE=ISO_DFLT_DATE

Default: US_DFLT_DATE