Administrator's Reference

SET SQLDATETIMEFORMAT (Set the Format for Date, Time, and Time Stamp for SQL Data)

Use this command to control the format in which SQL date, time, and time stamp data are displayed. See your SQL documentation for details about these formats.

Privilege Class

Any administrator can issue this command.

Syntax

                            .-Iso---.
>>-Set SQLDATETIMEformat----+-------+--------------------------><
                            +-Iso---+
                            +-Usa---+
                            +-Eur---+
                            +-Jis---+
                            '-Local-'
 

Parameters

Select one of the following formats:

Iso
Specifies the International Standards Organization (ISO) format. ISO is the default.

Usa
Specifies the IBM USA standard format.

Eur
Specifies the IBM European standard format.

Jis
Specifies the Japanese Industrial Standard Christian Era. Currently the JIS format is the same as the ISO format.

Local
Site-defined. Currently, the LOCAL format is the same as the ISO format.

Examples

Task

Set the format for SQL date, time, and time stamp data to ISO.

Command:
set sqldatetimeformat iso

Related Commands

Table 271. Commands Related to SET SQLDATETIMEFORMAT

Command Description
QUERY SQLSESSION Displays the current settings of the SQL formatting commands.
SELECT Allows customized queries of the TSM database.
SET SQLDISPLAYMODE Controls the column width in the display of SQL queries.
SET SQLMATHMODE Controls how decimal numbers are displayed in SQL queries.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]