use_timestamp

Use

Use this option o support the TIMESTAMP data type.

Description

In Oracle, the TIMESTAMP data type allows you to enter date or time values with ticks (1/100 second). . For example, for a field named F1 and defined as Time with packing code T5, you can enter a time value with ticks as follows: "11:12:13.22". You can also enter the value using ProcScript, where 22t means 22 ticks:

F1=$clock("11:12:13")+22t

Uniface to Oracle TIMESTAMP Mappings

Uniface Data Type	Field Interface Packing Code	Oracle Storage Format
Combined Date Time	E12	TIMESTAMP(6)
Combined Date Time	E13	TIMESTAMP(7)
Time	T5	TIMESTAMP(8)
Time	T6	TIMESTAMP(9)

The precision (0-9) specified with the TIMESTAMP data type specifies the number of digits in the fractional part of the seconds field. For example TIMESTAMP(6) supports a precision of 1/1000000 second.

Uniface only supports a precision up to 1/100 second, so some precision may be lost when using one of the Oracle TIMESTAMP data types.