Using the INTERVAL type

When calling a Java™ method with an expression evaluating to an INTERVAL, the runtime system converts the INTERVAL value to an instance of the com.fourjs.fgl.lang.FglInterval class implemented in FGLDIR/lib/fgl.jar. You can then manipulate the INTERVAL from within the Java code.

You must add FGLDIR/lib/fgl.jar to the class path in order to compile Java code with com.fourjs.fgl.lang.FglInterval class.

The com.fourjs.fgl.lang.FglInterval class implements following:

Table 1. Fields of the com.fourjs.fgl.lang.FglInterval class
Field Description 
final static int YEAR
 Time qualifier for year 
final static int MONTH
 Time qualifier for month 
final static int DAY
 Time qualifier for day 
final static int HOUR
 Time qualifier for hour 
final static int MINUTE
 Time qualifier for minute 
final static int SECOND
 Time qualifier for second 
final static int FRACTION
 Time qualifier for fraction (start qualifier) 
final static int FRACTION1
 Time qualifier for fraction(1) (end qualifier) 
final static int FRACTION2
 Time qualifier for fraction(2) (end qualifier) 
final static int FRACTION3
 Time qualifier for fraction(3) (end qualifier) 
final static int FRACTION4
 Time qualifier for fraction(4) (end qualifier) 
final static int FRACTION5
 Time qualifier for fraction(5) (end qualifier)
Table 2. Methods of the com.fourjs.fgl.lang.FglInterval class
Methods Description 
String toString()
 Converts the INTERVAL value to a String object representing an interval in default format. 
static void valueOf(
  String val)

Creates a new FglInterval object from a String object representing an interval value in format:

DD hh:mm:ss.fff

 
static void valueOf(
  String val,
  int startUnit,
  int endUnit)
 Creates a new FglDateTime object from a String object representing an interval value in standard format, using the qualifiers and precision passed as parameter. 
static int encodeTypeQualifier(
  int startUnit,
  int length,
  int endUnit))
 Returns the encoded type qualifier for an interval with to interval qualifiers and length passed:

encoded qualifier = (length * 256) + (startUnit * 16) + endUnit

Where length defines the total number of significant digits in this time data.

For example, with INTERVAL DAY(5) TO FRACTION3:

startUnit = DAY

length = 13 (DDDDhhmmssfff)

endUnit = FRACTION3
In the Java code, you can pass a com.fourjs.fgl.lang.FglInterval object as in this example:
public static void useInterval(FglInterval inv) throws ParseException {
    String s = inv.toString();
    ...
}
If you need to create an com.fourjs.fgl.lang.FglInterval object in your program, you can use the valueOf() class method as in this example:
IMPORT JAVA com.fourjs.fgl.lang.FglInterval
MAIN
  DEFINE inv com.fourjs.fgl.lang.FglInterval
  LET inv = FglInterval.valueOf("-510 12:33:45.123")
  DISPLAY inv.toString()
END MAIN