Class DateTimeFormatFunction

All Implemented Interfaces:
ExpressionWithVariableParameters, NamedExpression, HasSQL, Typed

public final class DateTimeFormatFunction extends FunctionN
A date-time format function.
  • Field Details

  • Constructor Details

    • DateTimeFormatFunction

      public DateTimeFormatFunction(int function)
  • Method Details

    • getValue

      public Value getValue(SessionLocal session, Value v1, Value v2, Value v3)
      Description copied from class: FunctionN
      Returns the value of this function.
      Overrides:
      getValue in class FunctionN
      Parameters:
      session - the session
      v1 - the value of first argument, or null
      v2 - the value of second argument, or null
      v3 - the value of third argument, or null
      Returns:
      the resulting value
    • formatDateTime

      public static String formatDateTime(SessionLocal session, Value date, String format, String locale, String timeZone)
      Formats a date using a format string.
      Parameters:
      session - the session
      date - the date to format
      format - the format string
      locale - the locale
      timeZone - the time zone
      Returns:
      the formatted date
    • parseDateTime

      public static ValueTimestampTimeZone parseDateTime(SessionLocal session, String date, String format, String locale, String timeZone)
      Parses a date using a format string.
      Parameters:
      session - the session
      date - the date to parse
      format - the parsing format
      locale - the locale
      timeZone - the time zone
      Returns:
      the parsed date
    • getDateFormat

      private static DateTimeFormatFunction.CacheValue getDateFormat(String format, String locale, String timeZone)
    • getZoneId

      private static ZoneId getZoneId(String timeZone)
    • optimize

      public Expression optimize(SessionLocal session)
      Description copied from class: Expression
      Try to optimize the expression.
      Specified by:
      optimize in class Expression
      Parameters:
      session - the session
      Returns:
      the optimized expression
    • getName

      public String getName()
      Description copied from interface: NamedExpression
      Get the name.
      Returns:
      the name in uppercase