public enum TimeUnit extends Enum<TimeUnit>
Only YEAR
, MONTH
, DAY
,
HOUR
, MINUTE
, SECOND
can be the unit of a SQL
interval.
The others (QUARTER
, WEEK
, MILLISECOND
,
DOW
, DOY
, EPOCH
, DECADE
, CENTURY
,
MILLENNIUM
, MICROSECOND
, NANOSECOND
, ISODOW
and ISOYEAR
) are convenient to use internally,
when converting to and from UNIX timestamps.
And also may be arguments to the EXTRACT
, TIMESTAMPADD
and
TIMESTAMPDIFF
functions.
Enum Constant and Description |
---|
CENTURY |
DAY |
DECADE |
DOW |
DOY |
EPOCH |
HOUR |
ISODOW |
ISOYEAR |
MICROSECOND |
MILLENNIUM |
MILLISECOND |
MINUTE |
MONTH |
NANOSECOND |
QUARTER |
SECOND |
WEEK |
YEAR |
Modifier and Type | Field and Description |
---|---|
BigDecimal |
multiplier |
char |
separator |
boolean |
yearMonth |
Modifier and Type | Method and Description |
---|---|
static TimeUnit |
getValue(int ordinal)
Returns the TimeUnit associated with an ordinal.
|
boolean |
isValidValue(BigDecimal field)
Returns whether a given value is valid for a field of this time unit.
|
static TimeUnit |
valueOf(String name)
Returns the enum constant of this type with the specified name.
|
static TimeUnit[] |
values()
Returns an array containing the constants of this enum type, in
the order they are declared.
|
public static final TimeUnit YEAR
public static final TimeUnit MONTH
public static final TimeUnit DAY
public static final TimeUnit HOUR
public static final TimeUnit MINUTE
public static final TimeUnit SECOND
public static final TimeUnit QUARTER
public static final TimeUnit ISOYEAR
public static final TimeUnit WEEK
public static final TimeUnit MILLISECOND
public static final TimeUnit MICROSECOND
public static final TimeUnit NANOSECOND
public static final TimeUnit DOW
public static final TimeUnit ISODOW
public static final TimeUnit DOY
public static final TimeUnit EPOCH
public static final TimeUnit DECADE
public static final TimeUnit CENTURY
public static final TimeUnit MILLENNIUM
public final boolean yearMonth
public final char separator
public final BigDecimal multiplier
public static TimeUnit[] values()
for (TimeUnit c : TimeUnit.values()) System.out.println(c);
public static TimeUnit valueOf(String name)
name
- the name of the enum constant to be returned.IllegalArgumentException
- if this enum type has no constant with the specified nameNullPointerException
- if the argument is nullpublic static TimeUnit getValue(int ordinal)
public boolean isValidValue(BigDecimal field)
field
- Field valueCopyright © 2012-2024 Apache Software Foundation. All Rights Reserved.