Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.0

# Modifiers

Each date and time function accepts zero or more modifier parameters that can be used to alter the date or time returned by the function. Modifiers are applied from left to right in the order specified.

The following modifiers can be used to add to the date/time:

- NNN day[s]
- NNN hour[s]
- NNN minute[s]
- NNN.NNNN second[s]
- NNN month[s]
- NNN year[s]

The following modifiers shift the date or time backward:

- start of month
- start of year
- start of day

The weekday modifier can be used to shift the date forward to the next date when the weekday number is N. Sunday starts at 0, Monday is 1, and so on.

- weekday N

The following modifiers can be used to convert the timevalue immediately preceding it to something else. For each of these modifiers, the results are undefined if the timevalue preceding it is not of the proper type.

- unixepoch
- localtime
- utc

The unixepoch modifier causes the timevalue preceding it to be interpreted as Unix Time (the number of seconds since January 1, 1970). The localtime and utc modifiers can be used to convert the timevalue immediately preceding it from UTC time to localtime or localtime to UTC time respectively.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

Copyright © 2009-2025. Cloud Software Group, Inc. All Rights Reserved.