PostgreSQL JDBC Driver 42.7.2 · org.postgresql.util.PGInterval

Modifier and Type	Field and Description
private int	days
private int	hours
private boolean	isNull
private static final int	MICROS_IN_SECOND
private int	microSeconds
private int	minutes
private int	months
private int	wholeSeconds
private int	years

Access	Constructor and Description
public	PGInterval() required by the driver.
public	PGInterval(String String representated interval (e.g. '3 years 2 mons') value) Initialize a interval with a given interval string representation.
public	PGInterval(int years years, int months months, int days days, int hours hours, int minutes minutes, double seconds seconds) Initializes all values of this interval to the specified values.

Method Summary

Modifier and Type	Method and Description
public void	add(Calendar Calendar instance to add to cal) Rolls this interval on a given calendar.
public void	add(Date Date instance to add to date) Rolls this interval on a given date.
public void	add(PGInterval intval to add interval) Add this interval's value to the passed interval.
public Object	clone() Overrides org.postgresql.util.PGobject.clone. This must be overridden to allow the object to be cloned.
public boolean	Returns: true if the two intervals are identical equals(@Nullable Object Object to compare with obj) Overrides java.lang.Object.equals. Returns whether an object is equal to this one or not.
public int	Returns: days represented by this interval getDays() Returns the days represented by this interval.
public int	Returns: hours represented by this interval getHours() Returns the hours represented by this interval.
public int	getMicroSeconds()
public int	Returns: minutes represented by this interval getMinutes() Returns the minutes represented by this interval.
public int	Returns: months represented by this interval getMonths() Returns the months represented by this interval.
public double	Returns: seconds represented by this interval getSeconds() Returns the seconds represented by this interval.
public @Nullable String	Returns: String represented interval getValue() Overrides org.postgresql.util.PGobject.getValue. Returns the stored interval information as a string.
public int	getWholeSeconds()
public int	Returns: years represented by this interval getYears() Returns the years represented by this interval.
public int	Returns: hashCode hashCode() Overrides org.postgresql.util.PGobject.hashCode. Returns a hashCode for this object.
private int	lookAhead(String value, int position, String find)
private static double	Returns: double parsed from string value nullSafeDoubleGet(@Nullable String double as string value value) Returns double value of value or 0 if value is null.
private static int	Returns: integer parsed from string value nullSafeIntGet(@Nullable String integer as string value value) Returns integer value of value or 0 if value is null.
private void	parseISO8601Format(String value)
public void	scale(int scale factor factor) Scale this interval by an integer factor.
public void	setDays(int days to set days) Set the days of this interval to the specified value.
public void	setHours(int hours to set hours) Set the hours of this interval to the specified value.
public void	setMinutes(int minutes to set minutes) Set the minutes of this interval to the specified value.
public void	setMonths(int months to set months) Set the months of this interval to the specified value.
public void	setSeconds(double seconds to set seconds) Set the seconds of this interval to the specified value.
public void	setValue(@Nullable String String representated interval (e.g. '3 years 2 mons') value) Sets a interval string represented value to this instance.
public void	setValue(int years years, int months months, int days days, int hours hours, int minutes minutes, double seconds seconds) Set all values of this interval to the specified values.
public void	setYears(int years to set years) Set the years of this interval to the specified value.

Inherited from org.postgresql.util.PGobject:: equals equals getType isNull setType setValue toString

days	back to summary
private int days

hours	back to summary
private int hours

isNull	back to summary
private boolean isNull

MICROS_IN_SECOND	back to summary
private static final int MICROS_IN_SECOND

microSeconds	back to summary
private int microSeconds

minutes	back to summary
private int minutes

months	back to summary
private int months

wholeSeconds	back to summary
private int wholeSeconds

years	back to summary
private int years

PGInterval	back to summary
public PGInterval() required by the driver.

PGInterval	back to summary
public PGInterval(String value) throws SQLException Initialize a interval with a given interval string representation. Parameters value:String String representated interval (e.g. '3 years 2 mons') Annotations @SuppressWarnings:method.invocation Exceptions SQLException: Is thrown if the string representation has an unknown format See Also `PGobject#setValue(String)`

PGInterval	back to summary
public PGInterval(int years, int months, int days, int hours, int minutes, double seconds) Initializes all values of this interval to the specified values. Parameters years:int years months:int months days:int days hours:int hours minutes:int minutes seconds:double seconds Annotations @SuppressWarnings:method.invocation See Also `setValue(int, int, int, int, int, double)`

Method Detail

add	back to summary
public void add(Calendar cal) Rolls this interval on a given calendar. Parameters cal:Calendar Calendar instance to add to

add	back to summary
public void add(Date date) Rolls this interval on a given date. Parameters date:Date Date instance to add to

add

back to summary

public void add(Date date)

Rolls this interval on a given date.

Parameters

date:Date: Date instance to add to

add	back to summary
public void add(PGInterval interval) Add this interval's value to the passed interval. This is backwards to what I would expect, but this makes it match the other existing add methods. Parameters interval:PGInterval intval to add

add

back to summary

public void add(PGInterval interval)

Add this interval's value to the passed interval. This is backwards to what I would expect, but this makes it match the other existing add methods.

Parameters

interval:PGInterval: intval to add

clone back to summary

clone	back to summary
public Object clone() throws CloneNotSupportedException Overrides org.postgresql.util.PGobject.clone. Doc from org.postgresql.util.PGobject.clone. This must be overridden to allow the object to be cloned. Returns:Object Doc from java.lang.Object.clone. a clone of this instance. Annotations @Override Exceptions CloneNotSupportedException: Doc from java.lang.Object.clone. if the object's class does not support the `Cloneable` interface. Subclasses that override the `clone` method can also throw this exception to indicate that an instance cannot be cloned.

public Object clone() throws CloneNotSupportedException

Overrides org.postgresql.util.PGobject.clone.

Doc from org.postgresql.util.PGobject.clone.

This must be overridden to allow the object to be cloned.

Returns:Object

Doc from java.lang.Object.clone.

a clone of this instance.

Annotations

@Override

Exceptions

CloneNotSupportedException:

Doc from java.lang.Object.clone.

if the object's class does not support the Cloneable interface. Subclasses that override the clone method can also throw this exception to indicate that an instance cannot be cloned.

equals	back to summary
public boolean equals(@Nullable Object obj) Overrides java.lang.Object.equals. Returns whether an object is equal to this one or not. Parameters obj:@Nullable Object Object to compare with Returns:boolean true if the two intervals are identical Annotations @Override

equals

back to summary

public boolean equals(@Nullable Object obj)

Overrides java.lang.Object.equals.

Returns whether an object is equal to this one or not.

Parameters

obj:@Nullable Object: Object to compare with

Returns:boolean

true if the two intervals are identical

Annotations

@Override

getDays	back to summary
public int getDays() Returns the days represented by this interval. Returns:int days represented by this interval

getDays

back to summary

public int getDays()

Returns the days represented by this interval.

Returns:int: days represented by this interval

getHours	back to summary
public int getHours() Returns the hours represented by this interval. Returns:int hours represented by this interval

getHours

back to summary

public int getHours()

Returns the hours represented by this interval.

Returns:int: hours represented by this interval

getMicroSeconds	back to summary
public int getMicroSeconds()

getMinutes	back to summary
public int getMinutes() Returns the minutes represented by this interval. Returns:int minutes represented by this interval

getMinutes

back to summary

public int getMinutes()

Returns the minutes represented by this interval.

Returns:int: minutes represented by this interval

getMonths	back to summary
public int getMonths() Returns the months represented by this interval. Returns:int months represented by this interval

getMonths

back to summary

public int getMonths()

Returns the months represented by this interval.

Returns:int: months represented by this interval

getSeconds	back to summary
public double getSeconds() Returns the seconds represented by this interval. Returns:double seconds represented by this interval

getSeconds

back to summary

public double getSeconds()

Returns the seconds represented by this interval.

Returns:double: seconds represented by this interval

getValue	back to summary
public @Nullable String getValue() Overrides org.postgresql.util.PGobject.getValue. Returns the stored interval information as a string. Returns:@Nullable String String represented interval Annotations @Override

getValue

back to summary

public @Nullable String getValue()

Overrides org.postgresql.util.PGobject.getValue.

Returns the stored interval information as a string.

Returns:@Nullable String

String represented interval

Annotations

@Override

getWholeSeconds	back to summary
public int getWholeSeconds()

getYears	back to summary
public int getYears() Returns the years represented by this interval. Returns:int years represented by this interval

getYears

back to summary

public int getYears()

Returns the years represented by this interval.

Returns:int: years represented by this interval

hashCode	back to summary
public int hashCode() Overrides org.postgresql.util.PGobject.hashCode. Returns a hashCode for this object. Returns:int hashCode Annotations @Override

hashCode

back to summary

public int hashCode()

Overrides org.postgresql.util.PGobject.hashCode.

Returns a hashCode for this object.

Returns:int

hashCode

Annotations

@Override

lookAhead	back to summary
private int lookAhead(String value, int position, String find)

nullSafeDoubleGet	back to summary
private static double nullSafeDoubleGet(@Nullable String value) throws NumberFormatException Returns double value of value or 0 if value is null. Parameters value:@Nullable String double as string value Returns:double double parsed from string value Exceptions NumberFormatException: if the string contains invalid chars

nullSafeDoubleGet

back to summary

private static double nullSafeDoubleGet(@Nullable String value) throws NumberFormatException

Returns double value of value or 0 if value is null.

Parameters

value:@Nullable String: double as string value

Returns:double

double parsed from string value

Exceptions

NumberFormatException:: if the string contains invalid chars

nullSafeIntGet	back to summary
private static int nullSafeIntGet(@Nullable String value) throws NumberFormatException Returns integer value of value or 0 if value is null. Parameters value:@Nullable String integer as string value Returns:int integer parsed from string value Exceptions NumberFormatException: if the string contains invalid chars

nullSafeIntGet

back to summary

private static int nullSafeIntGet(@Nullable String value) throws NumberFormatException

Returns integer value of value or 0 if value is null.

Parameters

value:@Nullable String: integer as string value

Returns:int

integer parsed from string value

Exceptions

NumberFormatException:: if the string contains invalid chars

parseISO8601Format	back to summary
private void parseISO8601Format(String value)

scale	back to summary
public void scale(int factor) Scale this interval by an integer factor. The server can scale by arbitrary factors, but that would require adjusting the call signatures for all the existing methods like getDays() or providing our own justification of fractional intervals. Neither of these seem like a good idea without a strong use case. Parameters factor:int scale factor

scale

back to summary

public void scale(int factor)

Scale this interval by an integer factor. The server can scale by arbitrary factors, but that would require adjusting the call signatures for all the existing methods like getDays() or providing our own justification of fractional intervals. Neither of these seem like a good idea without a strong use case.

Parameters

factor:int: scale factor

setDays	back to summary
public void setDays(int days) Set the days of this interval to the specified value. Parameters days:int days to set

setDays

back to summary

public void setDays(int days)

Set the days of this interval to the specified value.

Parameters

days:int: days to set

setHours	back to summary
public void setHours(int hours) Set the hours of this interval to the specified value. Parameters hours:int hours to set

setHours

back to summary

public void setHours(int hours)

Set the hours of this interval to the specified value.

Parameters

hours:int: hours to set

setMinutes	back to summary
public void setMinutes(int minutes) Set the minutes of this interval to the specified value. Parameters minutes:int minutes to set

setMinutes

back to summary

public void setMinutes(int minutes)

Set the minutes of this interval to the specified value.

Parameters

minutes:int: minutes to set

setMonths	back to summary
public void setMonths(int months) Set the months of this interval to the specified value. Parameters months:int months to set

setMonths

back to summary

public void setMonths(int months)

Set the months of this interval to the specified value.

Parameters

months:int: months to set

setSeconds	back to summary
public void setSeconds(double seconds) Set the seconds of this interval to the specified value. Parameters seconds:double seconds to set

setSeconds

back to summary

public void setSeconds(double seconds)

Set the seconds of this interval to the specified value.

Parameters

seconds:double: seconds to set

setValue	back to summary
public void setValue(@Nullable String value) throws SQLException Sets a interval string represented value to this instance. This method only recognize the format, that Postgres returns - not all input formats are supported (e.g. '1 yr 2 m 3 s'). Parameters value:@Nullable String String representated interval (e.g. '3 years 2 mons') Annotations @Override Exceptions SQLException: Is thrown if the string representation has an unknown format

setValue

back to summary

public void setValue(@Nullable String value) throws SQLException

Sets a interval string represented value to this instance. This method only recognize the format, that Postgres returns - not all input formats are supported (e.g. '1 yr 2 m 3 s').

Parameters

value:@Nullable String: String representated interval (e.g. '3 years 2 mons')

Annotations

@Override

Exceptions

SQLException:: Is thrown if the string representation has an unknown format

setValue	back to summary
public void setValue(int years, int months, int days, int hours, int minutes, double seconds) Set all values of this interval to the specified values. Parameters years:int years months:int months days:int days hours:int hours minutes:int minutes seconds:double seconds

setValue

back to summary

public void setValue(int years, int months, int days, int hours, int minutes, double seconds)

Set all values of this interval to the specified values.

Parameters

years:int: years
months:int: months
days:int: days
hours:int: hours
minutes:int: minutes
seconds:double: seconds

setYears	back to summary
public void setYears(int years) Set the years of this interval to the specified value. Parameters years:int years to set

setYears

back to summary

public void setYears(int years)

Set the years of this interval to the specified value.

Parameters

years:int: years to set

public Class PGInterval

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail