Skip to main content

ftOraTimeStamp

ftOraTimeStamp = 40

Example​

function IsOracleTimestamp(Field: TField): Boolean;
begin
  Result := Field.DataType = ftOraTimeStamp;
end;

Usage​

ftOraTimeStamp identifies a provider-specific Oracle timestamp mapped by Velox to the structured TSQLTimeStamp field class.

Additional Technical Info​

ftOraTimeStamp is declaration ordinal 40 of TFieldType. It is the historic provider-specific marker for an Oracle timestamp.

The installed RTL maps it to TSQLTimeStampField, the same class used by ftTimeStamp, and treats both as base ftTimeStamp for compatibility. Its structured value contains year, month, day, hour, minute, second and a fractions field. Current Delphi conversion routines use millisecond fractions. The database/driver can support different precision and may round when crossing this boundary.

The member does not say whether the Oracle source column is a plain timestamp, a timestamp with local time zone, or a timestamp with time zone. In particular, TSQLTimeStamp itself contains no offset. Confirm the live column and provider mapping; otherwise timezone information can be normalised or lost before script code sees it.

AsDateTime converts to a timezone-free Delphi serial and can lose structure/precision. Prefer the structured field value/custom Variant when exact components matter. Text parsing and display depend on Delphi/provider formatting and should not be treated as a stable wire contract.

The example only inspects metadata and was source-reviewed; no Oracle connection, timestamp conversion, clock, dataset, database, runtime or image test ran.

External references

Created 2026-07-15