Script Date and Time Functions

The Automation Engine scripting language provides various elements that allow you to retrieve, define and modify dates and times in your scripts.

Date Calculations

Time Calculations

Return System Dates and Times

Convert Dates and Formats

  • CONV_DATE
    Converts a date to another date format

  • CONV_TIMESTAMP
    Converts a date and time for use in another time zone

  • DAY_OF_YEAR
    Returns the day of the year for a date

  • WEEK_NR
    Returns the calendar week for a date

  • WEEKDAY_NR
    Returns the day of the week for date as a number

  • WEEKDAY_XX
    Returns the day of the week for a date as an abbreviation

  • YEAR_9999
    Extracts the year from a given date

Validate Dates and Times

See also: