All Implemented Interfaces:

Serializable, Comparable<DayToSecond>, Interval
```
public final class DayToSecond
extends Number
implements Interval, Comparable<DayToSecond>
```
An implementation for the SQL standard INTERVAL DAY TO SECOND data type.
DayToSecond is a Number whose Number.intValue() represents the (truncated) number of milliseconds of the interval, Number.doubleValue() represents the approximative number of milliseconds (including hours, minutes, seconds, nanoseconds) of the interval.
Note: only a few databases actually support this data type on its own. You can still use it for date time arithmetic in other databases, though, through Field.add(Field) and Field.sub(Field) Databases that have been observed to natively support INTERVAL data types are:
These dialects have been observed to partially support INTERVAL data types in date time arithmetic functions, such as TIMESTAMPADD, and TIMESTAMPDIFF:
- SQLDialect.MARIADB
- SQLDialect.MYSQL
Author:

Lukas Eder

See Also:

Interval, Serialized Form

Constructor Summary

Constructors
Constructor	Description
`DayToSecond()`	Create a new interval.
`DayToSecond(int days)`	Create a new day interval.
`DayToSecond(int days, int hours)`	Create a new day-hour interval.
`DayToSecond(int days, int hours, int minutes)`	Create a new day-minute interval.
`DayToSecond(int days, int hours, int minutes, int seconds)`	Create a new day-second interval.
`DayToSecond(int days, int hours, int minutes, int seconds, int nano)`	Create a new day-nanoseconds interval.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`DayToSecond`	`abs()`	Get the absolute value of the interval (set its sign to positive)
`int`	`compareTo(DayToSecond that)`
`static DayToSecond`	`day(String string)`	Parse a string representation of a `INTERVAL DAY TO HOUR`.
`static DayToSecond`	`dayToHour(String string)`	Parse a string representation of a `INTERVAL DAY TO HOUR`.
`static DayToSecond`	`dayToMinute(String string)`	Parse a string representation of a `INTERVAL DAY TO MINUTE`.
`static DayToSecond`	`dayToSecond(String string)`	Parse a string representation of a `INTERVAL DAY TO SECOND`.
`double`	`doubleValue()`
`boolean`	`equals(Object obj)`
`float`	`floatValue()`
`int`	`getDays()`	Get the day-part of this interval
`int`	`getHours()`	Get the hour-part of this interval
`int`	`getMicro()`	Get the (truncated) micro-part of this interval
`int`	`getMilli()`	Get the (truncated) milli-part of this interval
`int`	`getMinutes()`	Get the minute-part of this interval
`int`	`getNano()`	Get the nano-part of this interval
`int`	`getSeconds()`	Get the second-part of this interval
`int`	`getSign()`	The sign of the interval
`double`	`getTotalDays()`	Get the whole interval in days
`double`	`getTotalHours()`	Get the whole interval in hours
`double`	`getTotalMicro()`	Get the whole interval in micro-seconds
`double`	`getTotalMilli()`	Get the whole interval in milli-seconds
`double`	`getTotalMinutes()`	Get the whole interval in minutes
`double`	`getTotalNano()`	Get the whole interval in nano-seconds
`double`	`getTotalSeconds()`	Get the whole interval in seconds
`int`	`hashCode()`
`static DayToSecond`	`hour(String string)`	Parse a string representation of a `INTERVAL HOUR`.
`static DayToSecond`	`hourToMinute(String string)`	Parse a string representation of a `INTERVAL HOUR TO MINUTE`.
`static DayToSecond`	`hourToSecond(String string)`	Parse a string representation of a `INTERVAL HOUR TO SECOND`.
`int`	`intValue()`
`long`	`longValue()`
`static DayToSecond`	`minute(String string)`	Parse a string representation of a `INTERVAL MINUTE`.
`static DayToSecond`	`minuteToSecond(String string)`	Parse a string representation of a `INTERVAL MINUTE TO SECOND`.
`DayToSecond`	`neg()`	Negate the interval (change its sign)
`static DayToSecond`	`second(String string)`	Parse a string representation of a `INTERVAL SECOND`.
`Duration`	`toDuration()`	Get a duration representation of this interval.
`String`	`toString()`
`static DayToSecond`	`valueOf(double milli)`	Load a `Double` representation of a `INTERVAL DAY TO SECOND` by assuming standard 24 hour days and 60 second minutes.
`static DayToSecond`	`valueOf(long second, int nanos)`	Load a `Double` representation of a `INTERVAL DAY TO SECOND` by assuming standard 24 hour days and 60 second minutes.
`static DayToSecond`	`valueOf(String string)`	Parse a string representation of a `INTERVAL DAY TO SECOND`.
`static DayToSecond`	`valueOf(Duration duration)`	Transform a `Duration` into a `DayToSecond` interval by taking its number of milliseconds.

Methods inherited from class java.lang.Number
byteValue, shortValue

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

Methods inherited from interface org.jooq.types.Interval
byteValue, shortValue

- Constructor Detail
  - DayToSecond
```
public DayToSecond()
```
    Create a new interval.
  - DayToSecond
```
public DayToSecond(int days)
```
    Create a new day interval.
  - DayToSecond
```
public DayToSecond(int days,
                   int hours)
```
    Create a new day-hour interval.
  - DayToSecond
```
public DayToSecond(int days,
                   int hours,
                   int minutes)
```
    Create a new day-minute interval.
  - DayToSecond
```
public DayToSecond(int days,
                   int hours,
                   int minutes,
                   int seconds)
```
    Create a new day-second interval.
  - DayToSecond
```
public DayToSecond(int days,
                   int hours,
                   int minutes,
                   int seconds,
                   int nano)
```
    Create a new day-nanoseconds interval.
- Method Detail
  - valueOf
```
public static DayToSecond valueOf(String string)
```
    Parse a string representation of a INTERVAL DAY TO SECOND.
    
    Parameters:
    
    string - A string representation of the form [+|-][days] [hours]:[minutes]:[seconds].[fractional seconds]
    
    Returns:
    
    The parsed INTERVAL DAY TO SECOND object, or null if the string could not be parsed.
  - day
```
public static DayToSecond day(String string)
```
    Parse a string representation of a INTERVAL DAY TO HOUR.
    
    Parameters:
    
    string - A string representation of the form [+|-][days]
    
    Returns:
    
    The parsed INTERVAL DAY object, or null if the string could not be parsed.
  - dayToHour
```
public static DayToSecond dayToHour(String string)
```
    Parse a string representation of a INTERVAL DAY TO HOUR.
    
    Parameters:
    
    string - A string representation of the form [+|-][days] [hours]
    
    Returns:
    
    The parsed INTERVAL DAY TO HOUR object, or null if the string could not be parsed.
  - dayToMinute
```
public static DayToSecond dayToMinute(String string)
```
    Parse a string representation of a INTERVAL DAY TO MINUTE.
    
    Parameters:
    
    string - A string representation of the form [+|-][days] [hours]:[minutes]
    
    Returns:
    
    The parsed INTERVAL DAY TO MINUTE object, or null if the string could not be parsed.
  - dayToSecond
```
public static DayToSecond dayToSecond(String string)
```
    Parse a string representation of a INTERVAL DAY TO SECOND.
    
    Parameters:
    
    string - A string representation of the form [+|-][days] [hours]:[minutes]:[seconds].[fractional seconds]
    
    Returns:
    
    The parsed INTERVAL DAY TO MINUTE object, or null if the string could not be parsed.
  - hour
```
public static DayToSecond hour(String string)
```
    Parse a string representation of a INTERVAL HOUR.
    
    Parameters:
    
    string - A string representation of the form [+|-][hours]
    
    Returns:
    
    The parsed INTERVAL HOUR object, or null if the string could not be parsed.
  - hourToMinute
```
public static DayToSecond hourToMinute(String string)
```
    Parse a string representation of a INTERVAL HOUR TO MINUTE.
    
    Parameters:
    
    string - A string representation of the form [+|-][hours]:[minutes]
    
    Returns:
    
    The parsed INTERVAL HOUR TO MINUTE object, or null if the string could not be parsed.
  - hourToSecond
```
public static DayToSecond hourToSecond(String string)
```
    Parse a string representation of a INTERVAL HOUR TO SECOND.
    
    Parameters:
    
    string - A string representation of the form [+|-][hours]:[minutes]:[seconds].[fractional seconds]
    
    Returns:
    
    The parsed INTERVAL HOUR TO SECOND object, or null if the string could not be parsed.
  - minute
```
public static DayToSecond minute(String string)
```
    Parse a string representation of a INTERVAL MINUTE.
    
    Parameters:
    
    string - A string representation of the form [+|-][minutes]
    
    Returns:
    
    The parsed INTERVAL MINUTE object, or null if the string could not be parsed.
  - minuteToSecond
```
public static DayToSecond minuteToSecond(String string)
```
    Parse a string representation of a INTERVAL MINUTE TO SECOND.
    
    Parameters:
    
    string - A string representation of the form [+|-][[minutes]:[seconds].[fractional seconds]
    
    Returns:
    
    The parsed INTERVAL MINUTE TO SECOND object, or null if the string could not be parsed.
  - second
```
public static DayToSecond second(String string)
```
    Parse a string representation of a INTERVAL SECOND.
    
    Parameters:
    
    string - A string representation of the form [+|-][seconds].[fractional seconds]
    
    Returns:
    
    The parsed INTERVAL SECOND object, or null if the string could not be parsed.
  - valueOf
```
public static DayToSecond valueOf(double milli)
```
    Load a Double representation of a INTERVAL DAY TO SECOND by assuming standard 24 hour days and 60 second minutes.
    
    Parameters:
    
    milli - The number of milliseconds as a fractional number
    
    Returns:
    
    The loaded INTERVAL DAY TO SECOND object
  - valueOf
```
public static DayToSecond valueOf(long second,
                                  int nanos)
```
    Load a Double representation of a INTERVAL DAY TO SECOND by assuming standard 24 hour days and 60 second minutes.
    
    Parameters:
    
    second - The number of seconds
    
    nanos - The number of nano seconds
    
    Returns:
    
    The loaded INTERVAL DAY TO SECOND object
  - valueOf
```
public static DayToSecond valueOf(Duration duration)
```
    Transform a Duration into a DayToSecond interval by taking its number of milliseconds.
  - toDuration
```
public final Duration toDuration()
```
    Description copied from interface: Interval
    Get a duration representation of this interval.
    There is an obvious Duration representation for DayToSecond intervals. If the interval contains YearMonth information, then the corresponding duration will use:
    
    1 year = 365.25 days
    
    1 month = 30 days
    
    This corresponds to PostgreSQL's EXTRACT(EPOCH FROM my_interval) behaviour.
    Specified by:
    
    toDuration in interface Interval
  - intValue
```
public final int intValue()
```
    Specified by:
    
    intValue in interface Interval
    
    Specified by:
    
    intValue in class Number
    
    See Also:
    
    Number.intValue()
  - longValue
```
public final long longValue()
```
    Specified by:
    
    longValue in interface Interval
    
    Specified by:
    
    longValue in class Number
    
    See Also:
    
    Number.longValue()
  - floatValue
```
public final float floatValue()
```
    Specified by:
    
    floatValue in interface Interval
    
    Specified by:
    
    floatValue in class Number
    
    See Also:
    
    Number.floatValue()
  - doubleValue
```
public final double doubleValue()
```
    Specified by:
    
    doubleValue in interface Interval
    
    Specified by:
    
    doubleValue in class Number
    
    See Also:
    
    Number.doubleValue()
  - neg
```
public final DayToSecond neg()
```
    Description copied from interface: Interval
    
    Negate the interval (change its sign)
    
    Specified by:
    
    neg in interface Interval
  - abs
```
public final DayToSecond abs()
```
    Description copied from interface: Interval
    
    Get the absolute value of the interval (set its sign to positive)
    
    Specified by:
    
    abs in interface Interval
  - getDays
```
public final int getDays()
```
    Get the day-part of this interval
  - getHours
```
public final int getHours()
```
    Get the hour-part of this interval
  - getMinutes
```
public final int getMinutes()
```
    Get the minute-part of this interval
  - getSeconds
```
public final int getSeconds()
```
    Get the second-part of this interval
  - getMilli
```
public final int getMilli()
```
    Get the (truncated) milli-part of this interval
  - getMicro
```
public final int getMicro()
```
    Get the (truncated) micro-part of this interval
  - getNano
```
public final int getNano()
```
    Get the nano-part of this interval
  - getTotalDays
```
public final double getTotalDays()
```
    Get the whole interval in days
  - getTotalHours
```
public final double getTotalHours()
```
    Get the whole interval in hours
  - getTotalMinutes
```
public final double getTotalMinutes()
```
    Get the whole interval in minutes
  - getTotalSeconds
```
public final double getTotalSeconds()
```
    Get the whole interval in seconds
  - getTotalMilli
```
public final double getTotalMilli()
```
    Get the whole interval in milli-seconds
  - getTotalMicro
```
public final double getTotalMicro()
```
    Get the whole interval in micro-seconds
  - getTotalNano
```
public final double getTotalNano()
```
    Get the whole interval in nano-seconds
  - getSign
```
public final int getSign()
```
    Description copied from interface: Interval
    
    The sign of the interval
    
    Specified by:
    
    getSign in interface Interval
    
    Returns:
    
    1 for positive or zero, -1 for negative
  - compareTo
```
public final int compareTo(DayToSecond that)
```
    Specified by:
    
    compareTo in interface Comparable<DayToSecond>
  - hashCode
```
public final int hashCode()
```
    Overrides:
    
    hashCode in class Object
  - equals
```
public final boolean equals(Object obj)
```
    Overrides:
    
    equals in class Object
  - toString
```
public final String toString()
```
    Overrides:
    
    toString in class Object

Class DayToSecond

Constructor Summary

Method Summary

Methods inherited from class java.lang.Number

Methods inherited from class java.lang.Object

Methods inherited from interface org.jooq.types.Interval

Constructor Detail

DayToSecond

DayToSecond

DayToSecond

DayToSecond

DayToSecond

DayToSecond

Method Detail

valueOf

day

dayToHour

dayToMinute

dayToSecond

hour

hourToMinute

hourToSecond

minute

minuteToSecond

second

valueOf

valueOf

valueOf

toDuration

intValue

longValue

floatValue

doubleValue

neg

abs

getDays

getHours

getMinutes

getSeconds

getMilli

getMicro

getNano

getTotalDays

getTotalHours

getTotalMinutes

getTotalSeconds

getTotalMilli

getTotalMicro

getTotalNano

getSign

compareTo

hashCode

equals

toString