The IntervalDF Class

The com.informix.lang.IntervalDF class allows you to manipulate intervals.

Using IntervalDF Constructors

The default constructor is defined as follows:

public IntervalDF() throws SQLException

Use this second version of the default constructor to display localized error messages if an exception is thrown:

public IntervalDF(Connection conn) throws SQLException

Use the following constructors to create intervals from specific input values:

• Two time stamps t1 and t2, returning the IntervalDF value that equals t1 - t2:

  public IntervalDF(Timestamp t1, Timestamp t2) 
                        throws SQLException
  
  public IntervalDF(Timestamp t1, Timestamp t2,
            Connection conn) throws SQLException

  The second version allows you to support localized error messages.

• A number of seconds and nanoseconds (large second values are converted to minutes, hours, or days):

  public IntervalDF(long seconds, long nanos) 
                        throws SQLException
  
  public IntervalDF(long seconds, long nanos, Connection conn) throws SQLException

  The second version allows you to support localized error messages.

• A number of seconds, a number of nanoseconds, and qualifier:

  public IntervalDF(long seconds, long nanos, 
          short qualifier) throws SQLException
  
  public IntervalDF(long seconds, long nanos, 
  short qualifier, Connection conn) throws SQLException

  To specify the qualifier, you can use the getQualifier() method described in Using Interval Methods. The second version allows you to support localized error messages.

• A string:

  public IntervalDF(String string) 
                        throws SQLException
  public IntervalDF(String string, Connection conn) 
                        throws SQLException

  The second version allows you to support localized error messages.

  When you use these constructors, the default qualifier is set to the following values:

  leading field precision: 2start code: TU_DAYend code: TU_F5

  For information about string INTERVAL formats, refer to the IBM Informix: Guide to SQL Syntax.

• A string and a qualifier:

  public IntervalDF(String string, short qualifier)
                        throws SQLException
  
  public IntervalDF(String string, short qualifier, Connection conn) throws SQLException

  To specify the qualifier, you can use the getQualifier() method described in Using Interval Methods. The second version allows you to support localized error messages.

• A string and qualifier information:

  public IntervalDF(String string, int length, byte startcode,
  byte endcode) throws SQLException
  
  public IntervalDF(String string, int length, byte startcode,
  byte endcode, Connection conn) throws SQLException

  The second version allows you to support localized error messages.

Using IntervalDF Methods

The following methods allow you to manipulate intervals. (You can also use the Interval methods, described previously.) The tasks you can perform, and the methods you can use, are as follows:

• Comparing two intervals:

  boolean equals(Object other)
  boolean greaterThan(IntervalDF other)
  boolean lessThan(IntervalDF other)

• Setting a value for an interval from:
  • A string:

    void fromString(String other)
    void set(String string)

  • Second and nanosecond values (large second values are converted to minutes, hours, or days):

    void set(long seconds, long nanos)

  • Two time stamps:

    void set(Timestamp t1, Timestamp t2)

• Setting the qualifier from the length, start code, and end code:

  void setQualifier(int length, byte startcode, byte endcode)

• Obtaining the number of nanoseconds in the interval:

  long getNanoSeconds()

• Obtaining the number of seconds in the interval:

  long getSeconds()

• Creating a string representation of the interval in the format ddddd hh:mm:ss.nano:

  String toString()

  The fields present depend on the qualifier. Blanks replace leading zeros.