ODAC

TOraInterval.AsString Property

Used to get and set the interval value as string.

Class

TOraInterval

Syntax

property AsString: string;

Remarks

Use the AsString property to get and set the interval value as string. Oracle establishes certain formats for each interval type.

INTERVAL YEAR TO MONTH format:

'[year-]month'.

INTERVAL DAY TO SECOND formats:

'seconds',

'minutes[:seconds]',

'hours[:minutes:[seconds]]',

'days[ hours[:minutes:[seconds]]]'.

Optional fields are surrounded by brackets.

Reading AsString property when IsNull is True returns an empty string.

See Also

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback