3. Statements : OpenROAD SQL Statements : Set Statement : Date_format
 
Share this page                  
Date_format
Set date_format specifies the format for date values. This option corresponds to the Ingres environment variable II_DATE_FORMAT and is assigned the same values. If set, date_format replaces the currently configured format with an alternate format. The default format setting is US. See the Workbench User Guide for a list of valid settings.
To set the date_format from within a 4GL routine, you must pass the set date_format a variable containing the desired format with single quotes before and after the date format string. For example:
initialize()=
declare
          df = varchar(20) not null;
enddeclare
{
          df = '''MULTINATIONAL''';
          set date_format :df;
}