Date and Interval Routines

This section contains routines that enable users to deal with dates.

Routines Summary

  • addMonths — Adds a number of months to a specified date, preserving the day of month where possible.

  • currentDate — Returns the current date.

  • day — Returns a number representing the day of month: 1-31.

  • dayOfWeek — Returns the day of week.

  • endOfMonth — Returns a date set on the last day of the month for the given date. Also sets hours/minutes/seconds/milliseconds to their respective maximum value.

  • formatDate — Formats the given date into a date/time string accordingly to the given format expression.

  • hour — Returns the hour of the provided date: 0-23.

  • millisToDate — Converts milliseconds to a date.

  • millisToInterval — Converts milliseconds to a time interval.

  • minute — Returns the minutes of the provided date: 0-59.

  • month — Returns a number representing the month of the provided date (1-12).

  • monthName — Returns the month name of the provided date.

  • parseDate — Returns the parsed date according to the format you provided. If parse fails, it will return a null date.

  • second — Returns the seconds of the provided date: 0-59.

  • startOfDay — Returns a date, but strips off the hours, minutes and seconds.

  • startOfMonth — Returns a date set on the first day of the month for the given date. Also sets hours/minutes/seconds to 0.

  • toDate — Creates a date value from the specified parameters.

  • toJiraDateFormat — Displays the given date using Jira format.

  • toRawWorkingInterval — Returns a date interval converted to the specified number of hours per day.

  • toTimeZone — Converts a date to the specified time zone.

  • week — Returns the week number in the year of the provided date.

  • year — Returns the year of the provided date.

Peacock