TOraInterval.AsString Property

Used to get and set the interval value as string.

property AsString: string;

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.