Package dev.frostlake.functions.scalar.conversion

Class ToDate

java.lang.Object
dev.frostlake.functions.BuiltInFunction
dev.frostlake.functions.scalar.conversion.ToDate
Direct Known Subclasses:
DateFunction
public class ToDate extends BuiltInFunction

  • Constructor Details

    • ToDate

      public ToDate()

    • ToDate

      protected ToDate(String name)

  • Method Details

    • 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

    • acceptsNumericEpoch

      protected boolean acceptsNumericEpoch()
      Whether a NUMBER argument may be read as an epoch. Live-verified on a real account: TO_DATE(1631711999) and TRY_TO_DATE(1631711999) both fail "invalid type [TO_DATE(1631711999)] for parameter 'TO_DATE'", while the DATE() alias of the very same function returns 2021-09-15 and TO_TIMESTAMP(1631711999) works — so the restriction belongs to the TO_DATE spelling, not to the epoch conversion. A numeric STRING stays legal (TO_DATE('1631711999') is 2021-09-15).

    • vectorRejection

      public SemiStructuredRejection vectorRejection(int position)
      A VECTOR is refused as the conversion's own invalid type, as TO_CHAR refuses it.
      Overrides:
      vectorRejection in class BuiltInFunction
      Parameters:
      position - the zero-based argument position being asked about
      Returns:
      the refusal this position gives a VECTOR value; by default none

    • 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