DayToSecond (jOOQ 2.5.0 API)

Overview

Package

Class

Use

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.jooq.types
Class DayToSecond

java.lang.Object
  java.lang.Number
      org.jooq.types.DayToSecond

All Implemented Interfaces:: Serializable, Comparable<DayToSecond>, Interval

public final class DayToSecond
extends Number
implements Interval, Comparable<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:

Author:: Lukas Eder
See Also:: Interval, Serialized Form

Constructor Summary
`DayToSecond(int days)` Create a new day-hour interval.
`DayToSecond(int days, int hours)` Create a new day-hour interval.
`DayToSecond(int days, int hours, int minutes)` Create a new day-hour interval.
`DayToSecond(int days, int hours, int minutes, int seconds)` Create a new day-hour interval.
`DayToSecond(int days, int hours, int minutes, int seconds, int nano)` Create a new day-hour interval.

Method Summary
`DayToSecond`	`abs()` Get the absolute value of the interval (set its sign to positive)
`int`	`compareTo(DayToSecond that)`
`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()`
`int`	`intValue()`
`long`	`longValue()`
`DayToSecond`	`neg()` Negate the interval (change its sign)
`String`	`toString()`
`static DayToSecond`	`valueOf(double milli)` Load a `Double` representation of a `INTERVAL DAY TO SECOND`
`static DayToSecond`	`valueOf(String string)` Parse a string representation of a `INTERVAL DAY TO SECOND`

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