SiebelDateTime Function

Action

Reformats a string containing a date/time combination value in the same way as the Siebel 7 Web client does for the US-English locale.

Include file

Siebel7Web.bdh

Syntax

SiebelDateTime( inout sDateTime : string) : string;

Return value

Time string reformatted the same way as the Siebel 7 Web client does.

Parameter Description
sDateTime Date/Time string in the format as used in Siebel 7 server responses.

sDateTime must contain a date value followed by a time value, separated by at least one whitespace. The date value must be formatted in the same way as required by the function SiebelDate, the time value must be formatted in the same way as required by the function SiebelTime. The return value is reformatted in the same way as done by the functions SiebelDate and SiebelTime. The date and the time value are separated by one blank.

Example

transaction TDateTime
  begin
    Writeln(SiebelDateTime("01/01/2004 0:0:0"));
    Writeln(SiebelDateTime("1/1/2004 11:1:2"));
    Writeln(SiebelDateTime("09/09/2004 11:01:02"));
    Writeln(SiebelDateTime("10/01/2004 12:1:02"));
    Writeln(SiebelDateTime("01/10/2004 13:01:2"));
    Writeln(SiebelDateTime("12/31/2004 23:59:59"));
  end TDateTime;

Output

1/1/2004 12: 0: 0 AM
1/1/2004 11: 1: 2 AM
9/9/2004 11: 1: 2 AM
10/1/2004 12: 1: 2 PM
1/10/2004  1: 1: 2 PM
12/31/2004 11:59:59 PM