Versions Compared

Key

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

Functions which handle dates.

Date-time functions operate on dates and date values and date-time values. The

Type
Description
DateA date.
DatetimeA date and time.

 The following date-time functions are available:

Page Tree
root@self
excerpttrue

See Also

...

Arguments

Date-time functions can take arguments with the parameter types:

  • Date
  • Datetime

See Expression Basics.

Many date-time functions use take the arguments DateField and DateValue dateField and dateValue, which are explained below.

Anchor
dateField
dateField

...

dateField

DateField dateField can take one of the following values:

  • _YEAR
  • _MONTH
  • _DAY (equivalent to _DAY_OF_MONTH)
  • _DAY_OF_WEEK
  • _DAY_OF_MONTH
  • _DAY_OF_YEAR
  • _WEEK_OF_YEAR
  • _HOUR
  • _MINUTE
  • _SECOND
  • _MILLISECOND

Anchor
dateValue
dateValue

...

dateValue

DateValue dateValue can either be a number, representing a month or day, or a constant.

...

Note

When scheduling tasks, the days of the week are represented by different numbers.

See Also

...



Excerpt
hiddentrue

Functions which handle dates.