@Override protected void appendExtractFunction(ASTExtract functionExpression) { out.append("datepart("); switch (functionExpression.getPart()) { case DAY_OF_MONTH: out.append("day"); break; case DAY_OF_WEEK: out.append("weekday"); break; case DAY_OF_YEAR: out.append("dayofyear"); break; default: out.append(functionExpression.getPart().name().toLowerCase()); } out.append(" , "); } }
@Override protected void appendExtractFunction(ASTExtract functionExpression) { out.append("DATEPART("); switch (functionExpression.getPart()) { case DAY_OF_MONTH: out.append("DAY"); break; case DAY_OF_WEEK: out.append("WEEKDAY"); break; case DAY_OF_YEAR: out.append("DAYOFYEAR"); break; default: out.append(functionExpression.getPart().name()); } out.append(" , "); } }
@Override protected void appendExtractFunction(ASTExtract functionExpression) { switch (functionExpression.getPart()) { // use TO_CHAR(date, format) function for parts that is unsupported by EXTRACT() case DAY_OF_YEAR: case DAY_OF_WEEK: case WEEK: out.append("TO_CHAR("); break; case DAY_OF_MONTH: out.append("EXTRACT(DAY FROM "); break; default: out.append("EXTRACT("); out.append(functionExpression.getPart().name()); out.append(" FROM "); } }
/** * @since 4.0 */ @Override protected void appendExtractFunction(ASTExtract functionExpression) { switch (functionExpression.getPart()) { case DAY_OF_MONTH: out.append("DAY"); break; case DAY_OF_WEEK: case DAY_OF_YEAR: // db2 variants are without '_' out.append(functionExpression.getPart().name().replace("_", "")); break; default: appendFunction(functionExpression); } } }
@Override protected void appendExtractFunction(ASTExtract functionExpression) { out.append("EXTRACT("); switch (functionExpression.getPart()) { case DAY_OF_WEEK: case DAY_OF_YEAR: case WEEK: throw new CayenneRuntimeException("Function %s() is unsupported in FrontBase.", functionExpression.getPartCamelCaseName()); case DAY_OF_MONTH: out.append("DAY"); break; default: out.append(functionExpression.getPart().name()); } out.append(" FROM "); } }
@Override protected void appendExtractFunction(ASTExtract functionExpression) { switch (functionExpression.getPart()) { case DAY_OF_WEEK: case DAY_OF_MONTH: case DAY_OF_YEAR: // hsqldb variants are without '_' out.append(functionExpression.getPart().name().replace("_", "")); break; default: appendFunction(functionExpression); } } }
@Override protected void appendExtractFunction(ASTExtract functionExpression) { switch (functionExpression.getPart()) { case DAY_OF_WEEK: case DAY_OF_MONTH: case DAY_OF_YEAR: // mysql variants are without '_' out.append(functionExpression.getPart().name().replace("_", "")); break; default: appendFunction(functionExpression); } } }
@Override public String getFunctionName() { return part.name(); }
@Override protected void appendExtractFunction(ASTExtract functionExpression) { switch (functionExpression.getPart()) { case DAY_OF_WEEK: case DAY_OF_MONTH: case DAY_OF_YEAR: // ingres variants are without '_' out.append(functionExpression.getPart().name().replace("_", "")); break; default: appendFunction(functionExpression); } }
@Override protected void appendExtractFunction(ASTExtract functionExpression) { switch (functionExpression.getPart()) { case DAY_OF_WEEK: case DAY_OF_MONTH: case DAY_OF_YEAR: // openbase variants are without '_' out.append(functionExpression.getPart().name().replace("_", "")); break; default: appendFunction(functionExpression); } } }
/** * This method is used by FunctionExpressionFactory * @param part date/time part to extract */ public void setPart(DateTimePart part) { this.part = part; this.partName = nameToCamelCase(part.name()); }