OraDateToInt Function

Action

Converts an Oracle internal date to a date in integer format (YYYYMMDD).

Include file

Ora.bdh

Syntax

OraDateToInt( in sOraDate: string ): number;

Return value

date in the YYYYMMDD integer format

Parameter Description
sOraDate Oracle internal date in the SQLT_DAT format

Example

var
  cCursor: cursor;

dcltrans
  transaction TMain
  var
    sOraDate : string;
    nDate    : number;
  begin
    ...
    OraGetValue(cCursor, ":colDATE", sOraDate, 7);
    nDate := OraDateToInt(sOraDate);
    write(nDate); writeln;
  end TMain;