Class DateTimeFormatFunction

java.lang.Object

org.h2.expression.Expression

org.h2.expression.OperationN

org.h2.expression.function.FunctionN

org.h2.expression.function.DateTimeFormatFunction

All Implemented Interfaces:

ExpressionWithVariableParameters, NamedExpression, HasSQL, Typed

public final class DateTimeFormatFunction
extends FunctionN

A date-time format function.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
private static final class	DateTimeFormatFunction.CacheKey
private static final class	DateTimeFormatFunction.CacheValue

Field Summary

Fields

Modifier and Type	Field	Description
private static final LinkedHashMap<DateTimeFormatFunction.CacheKey, DateTimeFormatFunction.CacheValue>	CACHE
static final int	FORMATDATETIME	FORMATDATETIME() (non-standard).
private final int	function
private static final String[]	NAMES
static final int	PARSEDATETIME	PARSEDATETIME() (non-standard).

Fields inherited from class OperationN

args, argsCount, type

Fields inherited from class Expression

AUTO_PARENTHESES, MAP_IN_AGGREGATE, MAP_IN_WINDOW, MAP_INITIAL, WITH_PARENTHESES, WITHOUT_PARENTHESES

Fields inherited from interface HasSQL

ADD_PLAN_INFORMATION, DEFAULT_SQL_FLAGS, NO_CASTS, QUOTE_ONLY_WHEN_REQUIRED, REPLACE_LOBS_FOR_TRACE, TRACE_SQL_FLAGS

Constructor Summary

Constructors

Constructor	Description
DateTimeFormatFunction(int function)

Method Summary

Modifier and Type	Method	Description
static String	formatDateTime(SessionLocal session, Value date, String format, String locale, String timeZone)	Formats a date using a format string.
private static DateTimeFormatFunction.CacheValue	getDateFormat(String format, String locale, String timeZone)
String	getName()	Get the name.
Value	getValue(SessionLocal session, Value v1, Value v2, Value v3)	Returns the value of this function.
private static ZoneId	getZoneId(String timeZone)
Expression	optimize(SessionLocal session)	Try to optimize the expression.
static ValueTimestampTimeZone	parseDateTime(SessionLocal session, String date, String format, String locale, String timeZone)	Parses a date using a format string.

Methods inherited from class FunctionN

getUnenclosedSQL, getValue

Methods inherited from class OperationN

addParameter, doneWithParameters, getCost, getSubexpression, getSubexpressionCount, getType, isEverything, mapColumns, optimizeArguments, setEvaluatable, updateAggregate

Methods inherited from class Expression

addFilterConditions, createIndexConditions, getAlias, getBooleanValue, getColumnName, getColumnNameForView, getEnclosedSQL, getNonAliasExpression, getNotIfPossible, getNullable, getSchemaName, getSQL, getSQL, getSQL, getSQL, getTableAlias, getTableName, getWhenSQL, getWhenValue, isConstant, isIdentity, isNullConstant, isValueSet, isWhenConditionOperand, needParentheses, optimizeCondition, toString, writeExpressions, writeExpressions

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface HasSQL

getTraceSQL

Field Details

FORMATDATETIME

public static final int FORMATDATETIME

FORMATDATETIME() (non-standard).

See Also:

• Constant Field Values

PARSEDATETIME

public static final int PARSEDATETIME

PARSEDATETIME() (non-standard).

See Also:

• Constant Field Values

NAMES

private static final String[] NAMES

CACHE

private static final LinkedHashMap<DateTimeFormatFunction.CacheKey, DateTimeFormatFunction.CacheValue> CACHE

function

private final int function

Constructor Details

DateTimeFormatFunction

public DateTimeFormatFunction(int function)

Method Details

getValue

public Value getValue(SessionLocal session,
 Value v1,
 Value v2,
 Value v3)

Description copied from class: FunctionN

Returns the value of this function.

Overrides:

getValue in class FunctionN

Parameters:

session - the session

v1 - the value of first argument, or null

v2 - the value of second argument, or null

v3 - the value of third argument, or null

Returns:

the resulting value

formatDateTime

public static String formatDateTime(SessionLocal session,
 Value date,
 String format,
 String locale,
 String timeZone)

Formats a date using a format string.

Parameters:

session - the session

date - the date to format

format - the format string

locale - the locale

timeZone - the time zone

Returns:

the formatted date

parseDateTime

public static ValueTimestampTimeZone parseDateTime(SessionLocal session,
 String date,
 String format,
 String locale,
 String timeZone)

Parses a date using a format string.

Parameters:

session - the session

date - the date to parse

format - the parsing format

locale - the locale

timeZone - the time zone

Returns:

the parsed date

getDateFormat

private static DateTimeFormatFunction.CacheValue getDateFormat(String format,
 String locale,
 String timeZone)

getZoneId

private static ZoneId getZoneId(String timeZone)

optimize

public Expression optimize(SessionLocal session)

Description copied from class: Expression

Try to optimize the expression.

Specified by:

optimize in class Expression

Parameters:

session - the session

Returns:

the optimized expression

getName

public String getName()

Description copied from interface: NamedExpression

Get the name.

Returns:

the name in uppercase