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:
Examples
Task
Set the format for SQL date, time, and time stamp data to ISO.
Related Commands
Table 273. 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. |