public class ConversionFunctions extends AbstractFunctionHandler
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
DAY
Represents the
Calendar.DATE field, is: d. |
static java.lang.String |
DEFAULT_DATE_FORMAT_SPEC |
static java.lang.String |
DEFAULT_DATE_FORMAT_SPEC_2 |
static java.lang.String |
DEFAULT_DATE_FORMAT_SPEC_3 |
static java.lang.String |
HANDLER_ID |
static java.lang.String |
HOUR
Represents the
Calendar.HOUR_OF_DAY field, is: h. |
static java.lang.String |
MINUTE
Represents the
Calendar.MINUTE field, is: mi. |
static java.lang.String |
MONTH
Represents the
Calendar.MONTH field, is: m. |
static java.lang.String |
SECOND
Represents the
Calendar.SECOND field, is: s. |
static java.lang.String |
WEEK
Represents the
Calendar.WEEK_OF_YEAR field, is: w. |
static java.lang.String |
YEAR
Represents the
Calendar.YEAR field, is: y. |
q
Constructor and Description |
---|
ConversionFunctions() |
Modifier and Type | Method and Description |
---|---|
java.util.Date |
addTime(java.util.Date d,
java.lang.Double amount,
java.lang.String type) |
java.lang.String |
lower(java.lang.Object o) |
int |
timeField(java.lang.Object d,
java.lang.String type)
This method (function) will return the associated field from a
Calendar instance. |
java.util.Date |
to_date(java.lang.Object value) |
java.util.Date |
to_date(java.lang.String value,
java.lang.String spec) |
java.lang.Number |
to_number(java.lang.Object o) |
java.lang.String |
to_string(java.lang.Object o) |
java.util.Date |
toDate(java.lang.Object value) |
java.util.Date |
toDate(java.lang.String value,
java.lang.String spec) |
java.lang.Long |
toDateMillis(java.lang.String value,
java.lang.String spec) |
java.lang.Long |
toMillis(java.util.Date d) |
java.lang.Number |
toNumber(java.lang.Object o) |
java.lang.String |
toString(java.lang.Object o) |
java.lang.String |
upper(java.lang.Object o) |
setQuery
public static final java.lang.String HANDLER_ID
public static final java.lang.String MINUTE
Calendar.MINUTE
field, is: mi.public static final java.lang.String DAY
Calendar.DATE
field, is: d.public static final java.lang.String YEAR
Calendar.YEAR
field, is: y.public static final java.lang.String SECOND
Calendar.SECOND
field, is: s.public static final java.lang.String HOUR
Calendar.HOUR_OF_DAY
field, is: h.public static final java.lang.String MONTH
Calendar.MONTH
field, is: m.public static final java.lang.String WEEK
Calendar.WEEK_OF_YEAR
field, is: w.public static java.lang.String DEFAULT_DATE_FORMAT_SPEC
public static java.lang.String DEFAULT_DATE_FORMAT_SPEC_2
public static java.lang.String DEFAULT_DATE_FORMAT_SPEC_3
public int timeField(java.lang.Object d, java.lang.String type) throws QueryExecutionException
Calendar
instance. The type parm should be one of the
constants from this class. The default TimeZone
is used.d
- If the type is a long value then it is first converted to a Date.
Or a Date
should be used.type
- The type of field to get.Calendar
.QueryExecutionException
- If the d parm isn't an instance of
Long
or Date
.public java.util.Date addTime(java.util.Date d, java.lang.Double amount, java.lang.String type)
public java.util.Date toDate(java.lang.Object value) throws QueryExecutionException
QueryExecutionException
public java.util.Date to_date(java.lang.Object value) throws QueryExecutionException
QueryExecutionException
public java.util.Date to_date(java.lang.String value, java.lang.String spec) throws QueryExecutionException
QueryExecutionException
public java.util.Date toDate(java.lang.String value, java.lang.String spec) throws QueryExecutionException
QueryExecutionException
public java.lang.Long toMillis(java.util.Date d)
public java.lang.Long toDateMillis(java.lang.String value, java.lang.String spec) throws QueryExecutionException
QueryExecutionException
public java.lang.String upper(java.lang.Object o)
public java.lang.String lower(java.lang.Object o)
public java.lang.String to_string(java.lang.Object o)
public java.lang.String toString(java.lang.Object o)
public java.lang.Number to_number(java.lang.Object o)
public java.lang.Number toNumber(java.lang.Object o)