Package org.h2.expression.function

Class DayMonthNameFunction

java.lang.Object

org.h2.expression.Expression

org.h2.expression.Operation1

org.h2.expression.function.Function1

org.h2.expression.function.DayMonthNameFunction

All Implemented Interfaces:

NamedExpression, HasSQL, Typed

public final class DayMonthNameFunction
extends Function1

A DAYNAME() or MONTHNAME() function.

Field Summary

Fields

Modifier and Type	Field	Description
static final int	DAYNAME	DAYNAME() (non-standard).
private final int	function
static final int	MONTHNAME	MONTHNAME() (non-standard).
private static String[][]	MONTHS_AND_WEEKS	English names of months and week days.
private static final String[]	NAMES

Fields inherited from class org.h2.expression.Operation1

arg, type

Fields inherited from class org.h2.expression.Expression

AUTO_PARENTHESES, MAP_IN_AGGREGATE, MAP_IN_WINDOW, MAP_INITIAL, WITH_PARENTHESES, WITHOUT_PARENTHESES

Fields inherited from interface org.h2.util.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
DayMonthNameFunction(Expression arg, int function)

Method Summary

Modifier and Type	Method	Description
private static String[]	getMonthsAndWeeks(int field)	Return names of month or weeks.
String	getName()	Get the name.
Value	getValue(SessionLocal session)	Return the resulting value for the current row.
Expression	optimize(SessionLocal session)	Try to optimize the expression.

Methods inherited from class org.h2.expression.function.Function1

getUnenclosedSQL

Methods inherited from class org.h2.expression.Operation1

getCost, getSubexpression, getSubexpressionCount, getType, isEverything, mapColumns, setEvaluatable, updateAggregate

Methods inherited from class org.h2.expression.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 java.lang.Object

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

Methods inherited from interface org.h2.util.HasSQL

getTraceSQL

Field Details

DAYNAME

public static final int DAYNAME

DAYNAME() (non-standard).

See Also:

• Constant Field Values

MONTHNAME

public static final int MONTHNAME

MONTHNAME() (non-standard).

See Also:

• Constant Field Values

NAMES

private static final String[] NAMES

MONTHS_AND_WEEKS

private static volatile String[][] MONTHS_AND_WEEKS

English names of months and week days.

function

private final int function

Constructor Details

DayMonthNameFunction

public DayMonthNameFunction(Expression arg,
 int function)

Method Details

getValue

public Value getValue(SessionLocal session)

Description copied from class: Expression

Return the resulting value for the current row.

Specified by:

getValue in class Expression

Parameters:

session - the session

Returns:

the result

getMonthsAndWeeks

private static String[] getMonthsAndWeeks(int field)

Return names of month or weeks.

Parameters:

field - 0 for months, 1 for weekdays

Returns:

names of month or weeks

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