Interval

java.lang.Object
- org.h2.api.Interval

public final class Interval
extends java.lang.Object

INTERVAL representation for result sets.

Constructor Summary

Constructors
Constructor and Description

Interval(IntervalQualifier qualifier, boolean negative, long leading, long remaining)
Creates a new interval.

Constructors
Constructor and Description
`Interval(IntervalQualifier qualifier, boolean negative, long leading, long remaining)` Creates a new interval.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`boolean`	`equals(java.lang.Object obj)`
`long`	`getDays()` Returns days value, if any.
`long`	`getHours()` Returns hours value, if any.
`long`	`getLeading()` Returns value of leading field of this interval.
`long`	`getMinutes()` Returns minutes value, if any.
`long`	`getMonths()` Returns months value, if any.
`long`	`getNanosOfSecond()` Returns value of fractional part of seconds (in nanoseconds), if any.
`IntervalQualifier`	`getQualifier()` Returns qualifier of this interval.
`long`	`getRemaining()` Returns combined value of remaining fields of this interval.
`long`	`getSeconds()` Returns value of integer part of seconds, if any.
`long`	`getSecondsAndNanos()` Returns seconds value measured in nanoseconds, if any.
`long`	`getYears()` Returns years value, if any.
`int`	`hashCode()`
`boolean`	`isNegative()` Returns where the interval is negative.
`static Interval`	`ofDays(long days)` Creates a new INTERVAL DAY.
`static Interval`	`ofDaysHours(long days, int hours)` Creates a new INTERVAL DAY TO HOUR.
`static Interval`	`ofDaysHoursMinutes(long days, int hours, int minutes)` Creates a new INTERVAL DAY TO MINUTE.
`static Interval`	`ofDaysHoursMinutesNanos(long days, int hours, int minutes, long nanos)` Creates a new INTERVAL DAY TO SECOND.
`static Interval`	`ofDaysHoursMinutesSeconds(long days, int hours, int minutes, int seconds)` Creates a new INTERVAL DAY TO SECOND.
`static Interval`	`ofHours(long hours)` Creates a new INTERVAL HOUR.
`static Interval`	`ofHoursMinutes(long hours, int minutes)` Creates a new INTERVAL HOUR TO MINUTE.
`static Interval`	`ofHoursMinutesNanos(long hours, int minutes, long nanos)` Creates a new INTERVAL HOUR TO SECOND.
`static Interval`	`ofHoursMinutesSeconds(long hours, int minutes, int seconds)` Creates a new INTERVAL HOUR TO SECOND.
`static Interval`	`ofMinutes(long minutes)` Creates a new INTERVAL MINUTE.
`static Interval`	`ofMinutesNanos(long minutes, long nanos)` Creates a new INTERVAL MINUTE TO SECOND.
`static Interval`	`ofMinutesSeconds(long minutes, int seconds)` Creates a new INTERVAL MINUTE TO SECOND.
`static Interval`	`ofMonths(long months)` Creates a new INTERVAL MONTH.
`static Interval`	`ofNanos(long nanos)` Creates a new INTERVAL SECOND.
`static Interval`	`ofSeconds(long seconds)` Creates a new INTERVAL SECOND.
`static Interval`	`ofSeconds(long seconds, int nanos)` Creates a new INTERVAL SECOND.
`static Interval`	`ofYears(long years)` Creates a new INTERVAL YEAR.
`static Interval`	`ofYearsMonths(long years, int months)` Creates a new INTERVAL YEAR TO MONTH.
`java.lang.String`	`toString()`

Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - Interval
```
public Interval(IntervalQualifier qualifier,
                boolean negative,
                long leading,
                long remaining)
```
    Creates a new interval. Do not use this constructor, use static methods instead.
    
    Parameters:
    
    qualifier - qualifier
    
    negative - whether interval is negative
    
    leading - value of leading field
    
    remaining - combined value of all remaining fields
- Method Detail
  - ofYears
```
public static Interval ofYears(long years)
```
    Creates a new INTERVAL YEAR.
    
    Parameters:
    
    years - years, |years|<10¹⁸
    
    Returns:
    
    INTERVAL YEAR
  - ofMonths
```
public static Interval ofMonths(long months)
```
    Creates a new INTERVAL MONTH.
    
    Parameters:
    
    months - months, |months|<10¹⁸
    
    Returns:
    
    INTERVAL MONTH
  - ofDays
```
public static Interval ofDays(long days)
```
    Creates a new INTERVAL DAY.
    
    Parameters:
    
    days - days, |days|<10¹⁸
    
    Returns:
    
    INTERVAL DAY
  - ofHours
```
public static Interval ofHours(long hours)
```
    Creates a new INTERVAL HOUR.
    
    Parameters:
    
    hours - hours, |hours|<10¹⁸
    
    Returns:
    
    INTERVAL HOUR
  - ofMinutes
```
public static Interval ofMinutes(long minutes)
```
    Creates a new INTERVAL MINUTE.
    
    Parameters:
    
    minutes - minutes, |minutes|<10¹⁸
    
    Returns:
    
    interval
  - ofSeconds
```
public static Interval ofSeconds(long seconds)
```
    Creates a new INTERVAL SECOND.
    
    Parameters:
    
    seconds - seconds, |seconds|<10¹⁸
    
    Returns:
    
    INTERVAL SECOND
  - ofSeconds
```
public static Interval ofSeconds(long seconds,
                                 int nanos)
```
    Creates a new INTERVAL SECOND.
    If both arguments are not equal to zero they should have the same sign.
    
    Parameters:
    
    seconds - seconds, |seconds|<10¹⁸
    
    nanos - nanoseconds, |nanos|<1,000,000,000
    
    Returns:
    
    INTERVAL SECOND
  - ofNanos
```
public static Interval ofNanos(long nanos)
```
    Creates a new INTERVAL SECOND.
    
    Parameters:
    
    nanos - nanoseconds (including seconds)
    
    Returns:
    
    INTERVAL SECOND
  - ofYearsMonths
```
public static Interval ofYearsMonths(long years,
                                     int months)
```
    Creates a new INTERVAL YEAR TO MONTH.
    If both arguments are not equal to zero they should have the same sign.
    
    Parameters:
    
    years - years, |years|<10¹⁸
    
    months - months, |months|<12
    
    Returns:
    
    INTERVAL YEAR TO MONTH
  - ofDaysHours
```
public static Interval ofDaysHours(long days,
                                   int hours)
```
    Creates a new INTERVAL DAY TO HOUR.
    If both arguments are not equal to zero they should have the same sign.
    
    Parameters:
    
    days - days, |days|<10¹⁸
    
    hours - hours, |hours|<24
    
    Returns:
    
    INTERVAL DAY TO HOUR
  - ofDaysHoursMinutes
```
public static Interval ofDaysHoursMinutes(long days,
                                          int hours,
                                          int minutes)
```
    Creates a new INTERVAL DAY TO MINUTE.
    Non-zero arguments should have the same sign.
    
    Parameters:
    
    days - days, |days|<10¹⁸
    
    hours - hours, |hours|<24
    
    minutes - minutes, |minutes|<60
    
    Returns:
    
    INTERVAL DAY TO MINUTE
  - ofDaysHoursMinutesSeconds
```
public static Interval ofDaysHoursMinutesSeconds(long days,
                                                 int hours,
                                                 int minutes,
                                                 int seconds)
```
    Creates a new INTERVAL DAY TO SECOND.
    Non-zero arguments should have the same sign.
    
    Parameters:
    
    days - days, |days|<10¹⁸
    
    hours - hours, |hours|<24
    
    minutes - minutes, |minutes|<60
    
    seconds - seconds, |seconds|<60
    
    Returns:
    
    INTERVAL DAY TO SECOND
  - ofDaysHoursMinutesNanos
```
public static Interval ofDaysHoursMinutesNanos(long days,
                                               int hours,
                                               int minutes,
                                               long nanos)
```
    Creates a new INTERVAL DAY TO SECOND.
    Non-zero arguments should have the same sign.
    
    Parameters:
    
    days - days, |days|<10¹⁸
    
    hours - hours, |hours|<24
    
    minutes - minutes, |minutes|<60
    
    nanos - nanoseconds, |nanos|<60,000,000,000
    
    Returns:
    
    INTERVAL DAY TO SECOND
  - ofHoursMinutes
```
public static Interval ofHoursMinutes(long hours,
                                      int minutes)
```
    Creates a new INTERVAL HOUR TO MINUTE.
    If both arguments are not equal to zero they should have the same sign.
    
    Parameters:
    
    hours - hours, |hours|<10¹⁸
    
    minutes - minutes, |minutes|<60
    
    Returns:
    
    INTERVAL HOUR TO MINUTE
  - ofHoursMinutesSeconds
```
public static Interval ofHoursMinutesSeconds(long hours,
                                             int minutes,
                                             int seconds)
```
    Creates a new INTERVAL HOUR TO SECOND.
    Non-zero arguments should have the same sign.
    
    Parameters:
    
    hours - hours, |hours|<10¹⁸
    
    minutes - minutes, |minutes|<60
    
    seconds - seconds, |seconds|<60
    
    Returns:
    
    INTERVAL HOUR TO SECOND
  - ofHoursMinutesNanos
```
public static Interval ofHoursMinutesNanos(long hours,
                                           int minutes,
                                           long nanos)
```
    Creates a new INTERVAL HOUR TO SECOND.
    Non-zero arguments should have the same sign.
    
    Parameters:
    
    hours - hours, |hours|<10¹⁸
    
    minutes - minutes, |minutes|<60
    
    nanos - nanoseconds, |seconds|<60,000,000,000
    
    Returns:
    
    INTERVAL HOUR TO SECOND
  - ofMinutesSeconds
```
public static Interval ofMinutesSeconds(long minutes,
                                        int seconds)
```
    Creates a new INTERVAL MINUTE TO SECOND.
    If both arguments are not equal to zero they should have the same sign.
    
    Parameters:
    
    minutes - minutes, |minutes|<10¹⁸
    
    seconds - seconds, |seconds|<60
    
    Returns:
    
    INTERVAL MINUTE TO SECOND
  - ofMinutesNanos
```
public static Interval ofMinutesNanos(long minutes,
                                      long nanos)
```
    Creates a new INTERVAL MINUTE TO SECOND.
    If both arguments are not equal to zero they should have the same sign.
    
    Parameters:
    
    minutes - minutes, |minutes|<10¹⁸
    
    nanos - nanoseconds, |nanos|<60,000,000,000
    
    Returns:
    
    INTERVAL MINUTE TO SECOND
  - getQualifier
```
public IntervalQualifier getQualifier()
```
    Returns qualifier of this interval.
    
    Returns:
    
    qualifier
  - isNegative
```
public boolean isNegative()
```
    Returns where the interval is negative.
    
    Returns:
    
    where the interval is negative
  - getLeading
```
public long getLeading()
```
    Returns value of leading field of this interval. For SECOND intervals returns integer part of seconds.
    
    Returns:
    
    value of leading field
  - getRemaining
```
public long getRemaining()
```
    Returns combined value of remaining fields of this interval. For SECOND intervals returns nanoseconds.
    
    Returns:
    
    combined value of remaining fields
  - getYears
```
public long getYears()
```
    Returns years value, if any.
    
    Returns:
    
    years, or 0
  - getMonths
```
public long getMonths()
```
    Returns months value, if any.
    
    Returns:
    
    months, or 0
  - getDays
```
public long getDays()
```
    Returns days value, if any.
    
    Returns:
    
    days, or 0
  - getHours
```
public long getHours()
```
    Returns hours value, if any.
    
    Returns:
    
    hours, or 0
  - getMinutes
```
public long getMinutes()
```
    Returns minutes value, if any.
    
    Returns:
    
    minutes, or 0
  - getSeconds
```
public long getSeconds()
```
    Returns value of integer part of seconds, if any.
    
    Returns:
    
    seconds, or 0
  - getNanosOfSecond
```
public long getNanosOfSecond()
```
    Returns value of fractional part of seconds (in nanoseconds), if any.
    
    Returns:
    
    nanoseconds, or 0
  - getSecondsAndNanos
```
public long getSecondsAndNanos()
```
    Returns seconds value measured in nanoseconds, if any.
    This method returns a long value that cannot fit all possible values of INTERVAL SECOND. For a very large intervals of this type use getSeconds() and getNanosOfSecond() instead. This method can be safely used for intervals of other day-time types.
    
    Returns:
    
    nanoseconds (including seconds), or 0
  - hashCode
```
public int hashCode()
```
    Overrides:
    
    hashCode in class java.lang.Object
  - equals
```
public boolean equals(java.lang.Object obj)
```
    Overrides:
    
    equals in class java.lang.Object
  - toString
```
public java.lang.String toString()
```
    Overrides:
    
    toString in class java.lang.Object

Class Interval

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

Interval

Method Detail

ofYears

ofMonths

ofDays

ofHours

ofMinutes

ofSeconds

ofSeconds

ofNanos

ofYearsMonths

ofDaysHours

ofDaysHoursMinutes

ofDaysHoursMinutesSeconds

ofDaysHoursMinutesNanos

ofHoursMinutes

ofHoursMinutesSeconds

ofHoursMinutesNanos

ofMinutesSeconds

ofMinutesNanos

getQualifier

isNegative

getLeading

getRemaining

getYears

getMonths

getDays

getHours

getMinutes

getSeconds

getNanosOfSecond

getSecondsAndNanos

hashCode

equals

toString