Syntax documentation standard_time_mask Locate the document in its SAP Library structure

Syntax Rules for Describing the Data Stream

Syntax

<standard_time_mask> ::= ISO | USA | EUR | JIS | INTERNAL

ISO

HH.MM.SS

USA

HH:MM AM (PM)

EUR

HH.MM.SS

JIS

HH:MM:SS

INTERNAL

HHHHMMSS

H stands for hours, M for minutes, and S for seconds.

Note

You can use the usual standard formats, or define your own format. To do this, use H for hours, M for minutes, and S for seconds. Use two figures for minutes and seconds. You can choose any number of figures for H.

Use

Use this syntax rule to specify the data format of the plain text values in which TIME columns are entered and output.

This format applies to both load and unload commands and SQL statements.

You can also change the current value for individual commands.

The default value of the SAP DB Loader is INTERNAL.