Entering content frame

Background documentation Time Specifications Locate the document in its SAP Library structure

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

This format only applies to the load or unload command in which it is specified. If a time format is not specified in a command, then either the Loader default is used, or a value specified with the SET TIME command. You use the SET TIME command to specify the time format for all subsequent commands. In a single Loader session, this applies until a new SET command is executed.

Syntax

<time_spec> ::= TIME <standard_time_mask> | TIME '<valFREE_MASK>'

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

valFREE_MASK

Freely definable output format

Use H for hours, M for minutes, and S for seconds. Minutes and seconds must have two digits. Hours must have two or four digits.

Explanation

TIME <standard_time_mask>

You use the standard_time_mask to specify the format for plain text values in which TIME columns are entered and displayed.

The default value in the Loader is INTERNAL.

'HHHH'

Hour (four digits)

'HH'

Hour (two digits)

'MM'

Minutes (two digits, 00-59)

'SS'

Seconds (two digits, 00-59)

 

Format

General Form

Example

EUR

'HH.MM.SS'

'14.30.08'

INTERNAL

'HHHHMMSS'

'00143008'

ISO/JIS

'HH:MM:SS'

'14:30:08'

USA

'HH:MM AM (PM)'

'2:30 PM'

Minutes and seconds must have two digits. Except in the format INTERNAL, the hours must have two digits. In the format INTERNAL, the hours must have two or four digits.

When data is loaded, hours greater than 24 cause errors, except in the format INTERNAL. When data is unloaded, hours are displayed modulo 24, except in the format INTERNAL. In the format INTERNAL, you can specify hours up to 9999.

Example

DATAEXTRACT * from reservation
OUTSTREAM 'reservation.data'
TIME ISO

TIME '<valFREE_MASK>'

You use the output format valFREEMASK to specify the format for plain text values in which TIME columns are entered and displayed.

Example

DATAEXTRACT * from reservation
OUTSTREAM 'reservation.data'
DATE 'HH:MM:SS'

Example of the content of the target data stream

"14:30:08"

 

Leaving content frame