/** * INTERNAL: * Build operator. */ public static ExpressionOperator leftPad() { return simpleThreeArgumentFunction(LeftPad, "LPAD"); }
/** * INTERNAL: * Build operator. */ public static ExpressionOperator dateDifference() { return simpleThreeArgumentFunction(DateDifference, "DATEDIFF"); }
/** * INTERNAL: * Build operator. */ public static ExpressionOperator rightPad() { return simpleThreeArgumentFunction(RightPad, "RPAD"); }
/** * INTERNAL: * Build operator. */ public static ExpressionOperator translate() { return simpleThreeArgumentFunction(Translate, "TRANSLATE"); }
private static final ExpressionOperator createLocate2Operator() { return ExpressionOperator.simpleThreeArgumentFunction(ExpressionOperator.Locate2, "LOCATE"); }
/** * INTERNAL: * Build operator. */ public static ExpressionOperator newTime() { return simpleThreeArgumentFunction(NewTime, "NEW_TIME"); }
/** * INTERNAL: * Build operator. */ public static ExpressionOperator replace() { return simpleThreeArgumentFunction(Replace, "REPLACE"); }
/** * INTERNAL: * Build operator. */ public static ExpressionOperator substring() { return simpleThreeArgumentFunction(Substring, "SUBSTR"); }
/** * INTERNAL: * Build locate operator with 3 params i.e. LOCATE("coffee", t0.DESCRIP, 4). * Last parameter is a start at. */ public static ExpressionOperator locate2() { ExpressionOperator expOperator = simpleThreeArgumentFunction(Locate2, "LOCATE"); int[] argumentIndices = new int[3]; argumentIndices[0] = 1; argumentIndices[1] = 0; argumentIndices[2] = 2; expOperator.setArgumentIndices(argumentIndices); return expOperator; }
/** * INTERNAL: * Build operator. */ public static ExpressionOperator addDate() { ExpressionOperator exOperator = simpleThreeArgumentFunction(AddDate, "DATEADD"); int[] indices = new int[3]; indices[0] = 1; indices[1] = 2; indices[2] = 0; exOperator.setArgumentIndices(indices); return exOperator; }
/** * INTERNAL: * create the Locate2 Operator for this platform */ public static ExpressionOperator locate2Operator() { ExpressionOperator result = ExpressionOperator.simpleThreeArgumentFunction(ExpressionOperator.Locate2, "CHARINDEX"); int[] argumentIndices = new int[3]; argumentIndices[0] = 1; argumentIndices[1] = 0; argumentIndices[2] = 2; result.setArgumentIndices(argumentIndices); return result; }
addOperator(ExpressionOperator.simpleFunction(ExpressionOperator.Length, "CHAR_LENGTH")); addOperator(ExpressionOperator.sybaseLocateOperator()); addOperator(ExpressionOperator.simpleThreeArgumentFunction(ExpressionOperator.Substring, "SUBSTRING")); addOperator(ExpressionOperator.addDate()); addOperator(ExpressionOperator.dateName());
addOperator(ExpressionOperator.simpleFunction(ExpressionOperator.CurrentTime, "GETDATE")); addOperator(ExpressionOperator.simpleFunction(ExpressionOperator.Length, "CHAR_LENGTH")); addOperator(ExpressionOperator.simpleThreeArgumentFunction(ExpressionOperator.Substring, "SUBSTRING")); addOperator(ExpressionOperator.addDate()); addOperator(ExpressionOperator.dateName());