Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • ADDTODATE Adds (or subtracts) time to a date using an integer and one date constant.
  • AFTER Tests if this date is after the specified date.
  • ASDATE Converts a character sequence to a date using predefined (dd-MM-yyyy hh:mm:ss, dd.MM.yyyy hh:mm:ss, dd-MM-yyyy, dd.MM.yyyy) or an optional date parse pattern.
  • BEFORE Tests if this date is before the specified date.
  • CEILINGDATE Rounds a date argument up to the beginning of the next date interval.
  • CRON_MATCHER Checks if the given date matches the given cron expression.
  • DAY Returns only the day of the month of a date. The day is given as an integer, ranging from 1 to 31.
  • DAYOFYEAR Returns the day of the year for the supplied date in a range from 1 to 366.
  • ENDOFMONTH Returns the date of the last day of month (ending in the evening at 11:59:59.999 PM / 23:59:59.999) for the given date.
  • ExcelConverter Converts integer dates from Excel to a date.
  • EXPAND_DATE_RANGE Expands a date range into multiple rows, one for each interval, one day by default.
  • FLOORDATE Rounds a date argument down to the beginning of the next date interval.
  • FORMATDATE Converts date to string by applying a format pattern.
  • FORMATDATE Converts date to string by applying a format pattern.
  • HOUR Returns only the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).
  • MILLISECOND Truncates a date to only display the milliseconds associate with the date.
  • MINUTE Returns only the minute of a time value
  • MIDNIGHT Returns the given date with a time of midnight (12:00:00 am).
  • MONTH Returns only the month of a date represented by a serial number.
  • MSTODATE Converts an integer representing a timestamp in milliseconds from January 1, 1970, 00:00:00 GMT to its corresponding date value.
  • NOW Returns the current date and time.
  • QUARTER Returns the quarter of the year for the supplied date in a range from 1 to 4.
  • ROUNDTIME Rounds a date field down to the nearest (s)econd, (m)inute, (h)our, or (d)ay set by a time constant.
  • SECOND Truncates a date to only display the seconds associate with the date.
  • SHIFTTIMEZONE Shift the date from one timezone to another.
  • STARTOFMONTH Returns the date of the first day of month (starting the morning at 00:00:00 / 12:00:00 AM) for the given date.
  • STARTOFWEEK Returns the date of the first day of week (Sunday night/Monday morning 00:00:00) for the given date.
  • TODAY Returns the current day (time at midnight).
  • TIMESTAMP Difference, measured in milliseconds, between the current time and midnight, January 1, 1970 UTC.
  • TIMESTAMPDIFF Returns the number of whole date intervals between two date arguments.
  • TODAY Returns the current day (time at midnight).
  • WEEKDAY Returns an integer between (1-7) corresponding to the day of the week of the date.
  • WEEKOFYEAR Returns the week of the year for the supplied date in a range from 1 to 53.
  • YEAR Returns the year corresponding to a date. The year is returned as an integer, ranging from 1900-9999.

...