@Override protected void appendExtractFunction(ASTExtract functionExpression) { out.append("EXTRACT("); switch (functionExpression.getPart()) { case DAY_OF_MONTH: out.append("day"); break; case DAY_OF_WEEK: out.append("dow"); break; case DAY_OF_YEAR: out.append("doy"); break; default: out.append(functionExpression.getPartCamelCaseName()); } out.append(" FROM "); } }
@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); } } }
@Override protected void appendExtractFunction(ASTExtract functionExpression) { out.append("EXTRACT("); 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("YEARDAY"); break; default: out.append(functionExpression.getPartCamelCaseName()); } out.append(" FROM "); } }
@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) { 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()) { // 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 "); } }
@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: case WEEK: throw new CayenneRuntimeException("Function %s() is unsupported in Derby." , functionExpression.getPartCamelCaseName()); default: super.appendExtractFunction(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 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) { 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) { 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(" , "); } }
/** * @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); } } }
out.append("cast(strftime("); switch (functionExpression.getPart()) { case YEAR: out.append("'%Y'");
/** * @since 4.0 */ @Override protected void clearLastFunctionArgDivider(ASTFunctionCall functionExpression) { if("CONCAT".equals(functionExpression.getFunctionName())) { out.delete(out.length() - " || ".length(), out.length()); } else { super.clearLastFunctionArgDivider(functionExpression); } if(functionExpression instanceof ASTExtract) { switch (((ASTExtract)functionExpression).getPart()) { case DAY_OF_YEAR: out.append(", 'DDD'"); break; case DAY_OF_WEEK: out.append(", 'D'"); break; case WEEK: out.append(", 'IW'"); break; } out.append(")"); } }