public class Trunc extends NumericArgumentFunction
  • Constructor Details

    • Trunc

      public Trunc()
  • Method Details

    • temporalRejection

      public SemiStructuredRejection temporalRejection(int position, int argumentCount)
      The temporal answer depends on the ARITY, because the temporal TRUNC is DATE_TRUNC with a unit (live-verified): TRUNC(d, 'MONTH') answers, TRUNC(d) alone is "Invalid argument types for function 'TRUNC': (DATE)" — and so are TRUNC(t), TRUNC(ts) and the TRUNCATE spelling — while a temporal in the SECOND position of a numeric call is the family refusal, "(NUMBER(2,1), DATE)". A temporal first argument's unit is judged by the unit rule instead, which is why the second position stays unconstrained when the first is temporal: TRUNC(d, d) is the date-part sentence, not "(DATE, DATE)".
      Overrides:
      temporalRejection in class BuiltInFunction
      Parameters:
      position - the zero-based argument position being asked about
      argumentCount - how many arguments the call carries
      Returns:
      the refusal this position gives a temporal value in a call of that arity
    • evaluate

      public Object evaluate(List<Object> args)
      Description copied from class: BuiltInFunction
      Computes the function's result over its already-evaluated argument values. A SQL NULL argument arrives as Java null, and returning null makes the SQL result NULL.
      Specified by:
      evaluate in class BuiltInFunction
      Parameters:
      args - the argument values, in call order
      Returns:
      the function's value for these arguments, or null for SQL NULL
    • getMinArgCount

      public int getMinArgCount()
      Description copied from class: BuiltInFunction
      The fewest arguments a call to this function may pass; fewer is an argument-count error.
      Specified by:
      getMinArgCount in class BuiltInFunction
      Returns:
      the minimum accepted argument count
    • getMaxArgCount

      public int getMaxArgCount()
      Description copied from class: BuiltInFunction
      The most arguments a call to this function may pass; Integer.MAX_VALUE marks a variadic function (see BuiltInFunction.isVariadic()).
      Specified by:
      getMaxArgCount in class BuiltInFunction
      Returns:
      the maximum accepted argument count