OraDateToString Function

Action

Converts an Oracle internal date to a string containing the date in the YYYY-MM-DD:hh.mm.ss format.

Include file

Ora.bdh

Syntax

OraDateToString(in  sOraDate  : string,
                out sDate     : string,
                in  nDateSize : number);
Parameter Description
sOraDate Oracle date in the SQLT_DAT format
sDate String receiving the date in the YYYY-MM-DD:hh.mm.ss format
nDateSize Size of the string buffer receiving the converted date

Example

var
  cCursor: cursor;

dcltrans
  transaction TMain
  var
    sOraDate, sDate: string;
  begin
    ...
    OraGetValue(cCursor, ":colDATE", sOraDate, 7);
    OraDateToString(sOraDate, sDate, sizeof(sDate));
    write(sDate); writeln;
  end TMain;