• addDays (Date date, Integer days) : Date
• addDays (Timestamp timestamp, Integer day) : Timestamp
• addHours (Time time, Integer hours) : Time
• addHours (Timestamp timestamp, Integer hour) : Timestamp
• addMillis (Time time, Integer seconds) : Time
• addMinutes (Time time, Integer minutes) : Time
• addMinutes (Timestamp timestamp, Integer minute) : Timestamp
• addMonths (Date date, Integer months) : Date
• addMonths (Timestamp timestamp, Integer month) : Timestamp
• addSeconds (Time time, Integer seconds) : Time
• addSeconds (Timestamp timestamp, Integer seconds) : Timestamp
• addTime (Time time1, Time time2) : Time
• addYears (Date date, Integer years) : Date
• addYears (Timestamp timestamp, Integer year) : Timestamp
• currentDate () : Date
• currentTime () : Time
• currentTimestamp () : Timestamp
• date (String text) : Date
• date (Integer year, Integer month, Integer day) : Date
• date (Timestamp timestamp) : Date
• day (Date date) : Integer
• dayOfMonth (Date date) : Integer
• dayOfMonth (Timestamp timestamp) : Integer
• dayOfWeek (Date date) : Integer
• dayOfWeek (Timestamp timestamp) : Integer
• dayOfYear (Date date) : Integer
• dayOfYear (Timestamp timestamp) : Integer
• defaultIfNull (Date value, Date defaultValue) : Date
• defaultIfNull (Time value, Time defaultValue) : Time
• defaultIfNull (Timestamp value, Timestamp defaultValue) : Timestamp
• diffDays (Date date1, Date date2) : Integer
• diffHours (Time time1, Time time2) : Integer
• diffHours (Timestamp timestamp1, Timestamp timestamp2) : Integer
• diffMillis (Time time1, Time time2) : Integer
• diffMinutes (Time time1, Time time2) : Integer
• diffMinutes (Timestamp timestamp1, Timestamp timestamp2) : Integer
• diffMonths (Date date1, Date date2) : Float
• diffSeconds (Time time1, Time time2) : Integer
• diffSeconds (Timestamp timestamp1, Timestamp timestamp2) : Integer
• diffTime (Time time1, Time time2) : Time
• diffYears (Date date1, Date date2) : Float
• executionStartDate () : Date
• formatDate (Date date) : String
• formatDate (Date date, String pattern) : String
• formatTimestamp (Timestamp timestamp, String pattern) : String
• hour (Time time) : Integer
• hour (Timestamp timestamp) : Integer
• isDate (String text) : Boolean
• isDate (Integer year, Integer month, Integer day) : Boolean
• max (Date List list) : Date
• max (Time List list) : Time
• max (Timestamp List list) : Timestamp
• milli (Time time) : Integer
• min (Date List list) : Date
• min (Time List list) : Time
• min (Timestamp List list) : Timestamp
• minute (Time time) : Integer
• minute (Timestamp timestamp) : Integer
• month (Date date) : Integer
• month (Timestamp timestamp) : Integer
• nano (Timestamp timestamp) : Integer
• second (Time time) : Integer
• second (Timestamp timestamp) : Integer
• subDays (Date date, Integer days) : Date
• subDays (Timestamp timestamp, Integer day) : Timestamp
• subHours (Time time, Integer hours) : Time
• subHours (Timestamp timestamp, Integer hours) : Timestamp
• subMillis (Time time, Integer millis) : Time
• subMinutes (Time time, Integer minutes) : Time
• subMinutes (Timestamp timestamp, Integer minute) : Timestamp
• subMonths (Date date, Integer months) : Date
• subMonths (Timestamp timestamp, Integer month) : Timestamp
• subSeconds (Time time, Integer seconds) : Time
• subSeconds (Timestamp timestamp, Integer second) : Timestamp
• subTime (Time time1, Time time2) : Time
• subYears (Date date, Integer years) : Date
• subYears (Timestamp timestamp, Integer year) : Timestamp
• time (String text) : Time
• time (Integer hour, Integer minute, Integer second) : Time
• time (Integer hour, Integer minute, Integer second, Integer millisecond) : Time
• time (Timestamp timestamp) : Time
• timestamp (String text) : Timestamp
• timestamp (Date date, Time time) : Timestamp
• timestamp (Integer year, Integer month, Integer day, Integer hour, Integer minute, Integer second, Integer nanosecond) : Timestamp
• weekDay (Date date) : Integer
• weekDayName (Date date) : String
• year (Date date) : Integer
• year (Timestamp timestamp) : Integer
4.1. addDays(Date date, Integer days)
Adds a number of days to a date.
Syntax. addDays (Date date, Integer days) : Date Parameters.
Name Type Description
date Date Date to which days should be added
days Integer Amount of days to be added to the date
Examples.
date = addDays(currentDate(), 10) addDays(#1999-12-12#, 10) = #1999-12-22#
4.2. addDays(Timestamp timestamp, Integer day)
Adds the value of day to object timestamp.
Syntax. addDays (Timestamp timestamp, Integer day) : Timestamp Parameters.
Name Type Description
timestamp Timestamp Timestamp object to which a number of days is added day Integer Number of days to be added to a given timestamp object
Examples.
time = addDays(currentTimestamp(), 1)
addDays(#2003-02-19 19:12:12#, 10) = #2003-03-01 19:12:12#
4.3. addHours(Time time, Integer hours)
Adds the given number of hours to object time.
Syntax. addHours (Time time, Integer hours) : Time Parameters.
Name Type Description
time Time time object, to which a number of hours is added hours Integer number of hours to be added to a given time object Examples.
time = addHours(currentTime(), 1) addHours(#19:12:12#, 10) = #05:12:12.000#
4.4. addHours(Timestamp timestamp, Integer hour)
Adds the value of hour to object timestamp.
Syntax. addHours (Timestamp timestamp, Integer hour) : Timestamp Parameters.
Name Type Description
timestamp Timestamp Timestamp object to which a number of hours is added hour Integer Number of hours to be added to a given timestamp object Examples.
time = addHours(currentTimestamp(), 1)
addHours(#2003-02-19 19:12:12#, 10) = #2003-02-20 05:12:12#
4.5. addMillis(Time time, Integer seconds)
Adds the given number of milliseconds to object time.
Syntax. addMillis (Time time, Integer seconds) : Time Parameters.
Name Type Description
time Time time object, to which a number auf milliseconds is added seconds Integer number of milliseconds to be added to a given time object
Examples.
time = addMillis(currentTime(), 1) addMillis(#19:12:12#, 10) = #19:12:12.010#
4.6. addMinutes(Time time, Integer minutes)
Adds the given number of minutes to object time.
Syntax. addMinutes (Time time, Integer minutes) : Time Parameters.
Name Type Description
time Time time object, to which a number auf minutes is added minutes Integer number of minutes to be added to a given time object Examples.
time = addMinutes(currentTime(), 1) addMinutes(#19:12:12#, 10) = #19:22:12.000#
4.7. addMinutes(Timestamp timestamp, Integer minute)
Adds the value of minute to object timestamp.
Syntax. addMinutes (Timestamp timestamp, Integer minute) : Timestamp Parameters.
Name Type Description
timestamp Timestamp Timestamp object to which a number of minutes is added minute Integer Number of minutes to be added to a given timestamp object Examples.
time = addMinutes(currentTimestamp(), 1)
addMinutes(#2003-02-19 19:12:12#, 10) = #2003-02-19 19:22:12#
4.8. addMonths(Date date, Integer months)
Adds a number of months to the date.
Syntax. addMonths (Date date, Integer months) : Date Parameters.
Name Type Description
date Date Date to add months to
months Integer Amount of months to be added to the date
Examples.
date = addMonths(currentDate(), 2) addMonths(#1999-12-12#, 4) = #2000-03-12#
4.9. addMonths(Timestamp timestamp, Integer month)
Adds the value of month to object timestamp.
Syntax. addMonths (Timestamp timestamp, Integer month) : Timestamp Parameters.
Name Type Description
timestamp Timestamp Timestamp object to which a number of month is added month Integer Number of months to be added to a given timestamp object Examples.
time = addMonths(currentTimestamp(), 1)
addMonths(#2003-02-19 19:12:12#, 10) = #2003-12-19 19:12:12#
4.10. addSeconds(Time time, Integer seconds)
Adds a given number of seconds to 'time'.
Syntax. addSeconds (Time time, Integer seconds) : Time Parameters.
Name Type Description
time Time time to which a number of seconds is added
seconds Integer number of seconds to be added to 'time' Examples.
time = addSeconds(currentTime(), 1) addSeconds(#19:12:12#, 10) = #19:12:22.000#
4.11. addSeconds(Timestamp timestamp, Integer seconds)
Adds a given number of seconds to 'timestamp'.
Syntax. addSeconds (Timestamp timestamp, Integer seconds) : Timestamp Parameters.
Name Type Description
timestamp Timestamp Timestamp to which the number of seconds is added seconds Integer Number of seconds to be added to 'timestamp'
Examples.
time = addSeconds(currentTimestamp(), 1)
addSeconds(#2003-02-19 19:12:12#, 10) = #2003-02-19 19:12:22#
4.12. addTime(Time time1, Time time2)
Adds a time object to another time object.
Syntax. addTime (Time time1, Time time2) : Time Parameters.
Name Type Description
time1 Time time object, to which another time object is added
time2 Time time object to be added
Examples.
time = addTime(currentTime(), #01:00:00#) addTime(#19:12:12#, #01:01:01#) = #20:13:13.000#
4.13. addYears(Date date, Integer years)
Adds a number of years to the date.
Syntax. addYears (Date date, Integer years) : Date Parameters.
Name Type Description
date Date Date to add years to
years Integer Amount of years to be added to the date Examples.
date = addYears(currentDate(), 2) addYears(#1999-12-12#, 4) = #2003-12-22#
4.14. addYears(Timestamp timestamp, Integer year)
Adds the value of year to object timestamp.
Syntax. addYears (Timestamp timestamp, Integer year) : Timestamp Parameters.
Name Type Description
timestamp Timestamp Timestamp object to which a number of years is added year Integer Number of years to be added to a given timestamp object
Examples.
time = addYears(currentTimestamp(), 1)
addYears(#2003-02-19 19:12:12#, 10) = #2013-02-19 19:12:12#
4.15. currentDate()
Returns the current date. This corresponds to the date on which the current record is processed and can be different for each record (e.g. if the project runs over midnight). To get a constant date during processing, use the executionStartDate() function.
Syntax. currentDate () : Date Examples.
currentDate() = #1999-12-15#
currentDate() = #1999-12-16#
4.16. currentTime()
Returns the current time. This time corresponds to the time the current record is executed. Thus, several records can differ in time.
Syntax. currentTime () : Time Examples.
currentTime() = #19:12:15.434#
4.17. currentTimestamp()
Returns the current timestamp. This timestamp corresponds to the time the current record is executed. Thus several records can differ in time.
Syntax. currentTimestamp () : Timestamp Examples.
currentTimestamp() = #2003-02-19 19:12:15.434123078#
4.18. date(String text)
Creates a date from text with format "yyyy-MM-dd". If the text can't be converted to a date an exception is returned.
Syntax. date (String text) : Date Parameters.
Name Type Description
text String Text which can be parsed to a date (format "yyyy-MM-dd") Examples.
date("1999-12-15") = #1999-12-15#
date("1999-A-B") An exception is returned
4.19. date(Integer year, Integer month, Integer day)
Creates a date from year, month and day parameters. If at least one of year, month or day is invalid (e.g.
negative) an exception is returned. This function is equal to the #year-month-day# - notation, but additionally enables the date function to use constants, properties and expressions.
Syntax. date (Integer year, Integer month, Integer day) : Date Parameters.
Name Type Description
year Integer Year
month Integer Month (between 1 and 12)
day Integer Day (between 1 and 31)
Examples.
date(1999, 12, 15) = #1999-12-15#
date(1999, 12, -5) An exception is returned
4.20. date(Timestamp timestamp)
Returns the date of timestamp as a Date object.
Syntax. date (Timestamp timestamp) : Date Parameters.
Name Type Description
timestamp Timestamp Timestamp object
Examples.
date(#2003-02-19 19:12:07#) = #2003-02-19#
4.21. day(Date date)
Returns the day of date.
Syntax. day (Date date) : Integer Parameters.
Name Type Description
date Date Date
Examples.
day(#1999-12-07#) = 7 day(currentDate()) = 3
day(birthDate) = 9 day(validDate) > 10
4.22. dayOfMonth(Date date)
Returns the day of month of date.
Syntax. dayOfMonth (Date date) : Integer Parameters.
Name Type Description
date Date Date
Examples.
dayOfMonth(#2003-02-19#) = 19
4.23. dayOfMonth(Timestamp timestamp)
Returns the day of month of timestamp.
Syntax. dayOfMonth (Timestamp timestamp) : Integer Parameters.
Name Type Description
timestamp Timestamp Timestamp object
Examples.
dayOfMonth(#2003-02-19 19:12:07.0#) = 19
4.24. dayOfWeek(Date date)
Returns the day of week of date. Week starts with sunday = 1 and ends with saturday = 7.
Syntax. dayOfWeek (Date date) : Integer Parameters.
Name Type Description
date Date Date
Examples.
dayOfWeek(#2003-02-19#) = 4
4.25. dayOfWeek(Timestamp timestamp)
Returns the day of week of timestamp. Week starts with sunday = 1 and ends with saturday = 7.
Syntax. dayOfWeek (Timestamp timestamp) : Integer
Parameters.
Name Type Description
timestamp Timestamp Timestamp object
Examples.
dayOfWeek(#2003-02-19 19:12:07.0#) = 4
4.26. dayOfYear(Date date)
Returns the day of year of date.
Syntax. dayOfYear (Date date) : Integer Parameters.
Name Type Description
date Date Date
Examples.
dayOfYear(#2003-02-19#) = 50
4.27. dayOfYear(Timestamp timestamp)
Returns the day of year of timestamp.
Syntax. dayOfYear (Timestamp timestamp) : Integer Parameters.
Name Type Description
timestamp Timestamp Timestamp object
Examples.
dayOfYear(#2003-02-19 19:12:07.0#) = 50
4.28. defaultIfNull(Date value, Date defaultValue)
Returns a default value if the provided value is null. Otherwise the given value is returned.
Syntax. defaultIfNull (Date value, Date defaultValue) : Date Parameters.
Name Type Description
value Date Value to be checked
defaultValue Date Default value to be set if value is null Examples.
date = defaultIfNull(null, currentDate())
defaultIfNull(#2012-02-10#, currentDate()) = #2012-02-10#
4.29. defaultIfNull(Time value, Time defaultValue)
Returns a default value if the provided value is null. Otherwise the given value is returned.
Syntax. defaultIfNull (Time value, Time defaultValue) : Time Parameters.
Name Type Description
value Time Value to be checked
defaultValue Time Default value to be set if value is null Examples.
time = defaultIfNull(null, currentTime())
defaultIfNull(#19:30:15#, currentTime()) = #19:30:15#
4.30. defaultIfNull(Timestamp value, Timestamp defaultValue)
Returns a default value if the provided value is null. Otherwise the given value is returned.
Syntax. defaultIfNull (Timestamp value, Timestamp defaultValue) : Timestamp Parameters.
Name Type Description
value Timestamp Value to be checked
defaultValue Timestamp Default value to be set if value is null Examples.
time = defaultIfNull(null, currentTimestamp())
defaultIfNull(#2005-05-05 19:30:15#, currentTimestamp()) = #2005-05-05 19:30:15#
4.31. diffDays(Date date1, Date date2)
Returns the difference in days between date1 and date2. If date1 is greater (i.e. later) than date2 the result is a positive value. Otherwise a negative value is returned.
Syntax. diffDays (Date date1, Date date2) : Integer Parameters.
Name Type Description
date1 Date Date
date2 Date Date
Examples.
diffDays(#1999-12-12#, #1999-12-07#) = 5
diffDays(#1999-12-07#, #1999-12-12#) = -5
4.32. diffHours(Time time1, Time time2)
Returns the difference between two time objects as number of hours. A positive result is returned, if the object time1 is greater (i.e. later) than the object time2, else a negative result is returned.
Syntax. diffHours (Time time1, Time time2) : Integer Parameters.
Name Type Description
time1 Time first time object
time2 Time second time object
Examples.
diffHours(#19:12:12#, #09:12:07#) = 10 diffHours(#19:12:12#, #09:13:00#) = 9 diffHours(#09:12:07#, #19:12:12#) = -10
4.33. diffHours(Timestamp timestamp1, Timestamp timestamp2)
Returns the difference between object timestamp1 and object timestamp2 as number of hours. A positive result is returned, if the object timestamp1 is greater (later) than the object timestamp2, else a negative result is returned.
Syntax. diffHours (Timestamp timestamp1, Timestamp timestamp2) : Integer Parameters.
Name Type Description
timestamp1 Timestamp first timestamp object timestamp2 Timestamp second timestamp object Examples.
diffHours(#2003-02-19 19:12:12#, #2003-02-19 09:12:07#) = 10 diffHours(#2003-02-19 19:12:12#, #2003-02-19 09:13:00#) = 9 diffHours(#2003-02-19 09:12:07#, #2003-02-19 19:12:12#) = -10
4.34. diffMillis(Time time1, Time time2)
Returns the difference between two time objects as number of milliseconds. A positive result is returned, if the object time1 is greater (i.e. later) than the object time2, else a negative result is returned.
Syntax. diffMillis (Time time1, Time time2) : Integer Parameters.
Name Type Description
time1 Time first time object
Name Type Description
time2 Time second time object
Examples.
diffMillis(#19:12:12#, #09:12:07#) = 36005000 diffMillis(#09:12:07#, #19:12:12#) = -36005000
4.35. diffMinutes(Time time1, Time time2)
Returns the difference between two time values in number of minutes. A positive result is returned, if 'time1' is greater (i.e. later) than 'time2', else a negative result is returned.
Syntax. diffMinutes (Time time1, Time time2) : Integer Parameters.
Name Type Description
time1 Time first time value
time2 Time second time value
Examples.
diffMinutes(#19:12:12#, #09:12:07#) = 600 diffMinutes(#19:12:12#, #09:13:00#) = 599 diffMinutes(#09:12:07#, #19:12:12#) = -600
4.36. diffMinutes(Timestamp timestamp1, Timestamp timestamp2)
Returns the difference between 'timestamp1' and 'timestamp2' in minutes. A positive result is returned, if timestamp1 is greater (later) than timestamp2, else a negative result is returned.
Syntax. diffMinutes (Timestamp timestamp1, Timestamp timestamp2) : Integer Parameters.
Name Type Description
timestamp1 Timestamp first timestamp timestamp2 Timestamp second timestamp Examples.
diffMinutes(#2003-02-19 19:12:12#, #2003-02-19 09:12:07#) = 600 diffMinutes(#2003-02-19 19:12:12#, #2003-02-19 09:13:00#) = 599 diffMinutes(#2003-02-19 09:12:07#, #2003-02-19 19:12:12#) = -600
4.37. diffMonths(Date date1, Date date2)
Returns the difference in months between date1 and date2. If date1 is greater (i.e. later) than date2 the result is a positive value. Otherwise a negative value is returned. Differences between dates containing the first, last or
same days of month are always integers. Otherwise a 31-day month is assumed and the difference is returned as a floating-point value.
Syntax. diffMonths (Date date1, Date date2) : Float Parameters.
Name Type Description
date1 Date Date
date2 Date Date
Examples.
diffMonths(#1999-2-28#, #1999-1-31#) = 1
diffMonths(#1999-10-12#,#1999-8-24#) BETWEEN [ 1.61 , 1.62 ]
4.38. diffSeconds(Time time1, Time time2)
Returns the difference between two time objects as number of seconds. A positive result is returned, if the object time1 is greater (i.e. later) than the object time2, else a negative result is returned.
Syntax. diffSeconds (Time time1, Time time2) : Integer Parameters.
Name Type Description
time1 Time first time object
time2 Time second time object
Examples.
diffSeconds(#19:12:12#, #09:12:07#) = 36005 diffSeconds(#09:12:07#, #19:12:12#) = -36005
4.39. diffSeconds(Timestamp timestamp1, Timestamp timestamp2)
Returns the difference between object timestamp1 and object timestamp2 as number of seconds. A positive result is returned, if the object timestamp1 is greater (later) than the object timestamp2, else a negative result is returned.
Syntax. diffSeconds (Timestamp timestamp1, Timestamp timestamp2) : Integer Parameters.
Name Type Description
timestamp1 Timestamp first timestamp object timestamp2 Timestamp second timestamp object Examples.
diffSeconds(#2003-02-19 19:12:12#, #2003-02-19 09:12:07#) = 36005 diffSeconds(#2003-02-19 09:12:07#, #2003-02-19 19:12:12#) = -36005
4.40. diffTime(Time time1, Time time2)
Returns the difference between two time objects as a new time object.
Syntax. diffTime (Time time1, Time time2) : Time Parameters.
Name Type Description
time1 Time first time object
time2 Time second time object
Examples.
time = diffTime(#24:00:00#, currentTime()) diffTime(#19:12:12#, #01:01:01#) = #18:11:11.000#
4.41. diffYears(Date date1, Date date2)
Returns the difference in years between date1 and date2. If date1 is greater (i.e. later) than date2 the result is a positive value. Otherwise a negative value is returned.
Syntax. diffYears (Date date1, Date date2) : Float Parameters.
Name Type Description
date1 Date Date
date2 Date Date
Examples.
diffYears(#2000-3-28#,#1999-3-28#) = 1
diffYears(#2000-10-12#,#1999-8-24#) BETWEEN [ 1.13 , 1.14 ]
4.42. executionStartDate()
Returns the starting date of the project. If the execution is started at e.g. 11:55pm and finished the next day, the returned date always corresponds to the date on which the execution was started.
Syntax. executionStartDate () : Date Examples.
executionStartDate() = #1999-12-15#
4.43. formatDate(Date date)
Formats the given date according to local standards.
Syntax. formatDate (Date date) : String Parameters.
Name Type Description
date Date Date
Examples.
formatDate(#2002-7-12#) = "July 12, 2002"
4.44. formatDate(Date date, String pattern)
Formats the given date using a specific pattern.
Syntax. formatDate (Date date, String pattern) : String Parameters.
Name Type Description
date Date Date to format
pattern String Pattern describing the date format Examples.
formatDate(#2008-12-31#, "MM/dd/yyyy") = "12/31/2008"
formatDate(#2008-12-31#, "yy-MM-dd") = "08-12-31"
4.45. formatTimestamp(Timestamp timestamp, String pattern)
Formats the given timestamp using a specific pattern.
Syntax. formatTimestamp (Timestamp timestamp, String pattern) : String Parameters.
Name Type Description
timestamp Timestamp Timestamp to format
pattern String Pattern describing the date and time format Examples.
formatTimestamp(#2010-02-11 19:12:07.434#, "MM/dd/yyyy HH:mm:ss.S") = "02/11/2010 19:12:07.434"
formatTimestamp(#2010-02-11 19:12:07.434#, "yy-MM-dd HH:mm:ss") = "10-02-11 19:12:07"
4.46. hour(Time time)
Returns the value of object time in hours.
Syntax. hour (Time time) : Integer Parameters.
Name Type Description
time Time Time object
Examples.
hour(addHours(#19:12:07#, 10)) = 5 hour(#19:12:07#) = 19
4.47. hour(Timestamp timestamp)
Returns the hour of timestamp.
Syntax. hour (Timestamp timestamp) : Integer Parameters.
Name Type Description
timestamp Timestamp Timestamp object
Examples.
hour(#2003-02-19 19:12:07#) = 19
4.48. isDate(String text)
Checks whether the parameter String can be converted to a date. If it can be converted, the function returns true.
Syntax. isDate (String text) : Boolean Parameters.
Name Type Description
text String Text which can be parsed to a date (format "yyyy-MM-dd") Examples.
isDate("1999-12-15") = true isDate("1999-A-B") = false
4.49. isDate(Integer year, Integer month, Integer day)
Checks whether the parameters can be converted to a date. If they can be converted, the function returns true.
Syntax. isDate (Integer year, Integer month, Integer day) : Boolean Parameters.
Name Type Description
year Integer Year of the date
month Integer Month of the date
day Integer Day of the date
Examples.
isDate(1999, 12, 15) = true isDate(1999, 31, 45) = false
4.50. max(Date List list)
Returns the maximum element of a collection Syntax. max (Date List list) : Date Parameters.
Name Type Description
list Date List List to check
Examples.
max({#2005-05-05# , #2005-10-06# , #2005-11-15#}) = #2005-11-15#
4.51. max(Time List list)
Returns the maximum element of a collection Syntax. max (Time List list) : Time Parameters.
Name Type Description
list Time List List to check
Examples.
max({#19:30:15# , #11:15:20# , #13:42:23#}) = #19:30:15#
4.52. max(Timestamp List list)
Returns the maximum element of a collection
Syntax. max (Timestamp List list) : Timestamp Parameters.
Name Type Description
list Timestamp List List to check Examples.
max({#2005-05-05 19:30:15# , #2005-11-15 11:15:20# , #2005-11-06 13:42:23#}) = #2005-11-15 11:15:20.0#
4.53. milli(Time time)
Returns the value of object time in milliseconds.
Syntax. milli (Time time) : Integer
Parameters.
Name Type Description
time Time time object
Examples.
milli(#19:12:07.666#) = 666
4.54. min(Date List list)
Returns the minimal element of a collection Syntax. min (Date List list) : Date Parameters.
Name Type Description
list Date List List to check
Examples.
min({#2005-05-05# , #2005-10-06# , #2005-11-15#}) = #2005-05-05#
4.55. min(Time List list)
Returns the minimal element of a collection Syntax. min (Time List list) : Time Parameters.
Name Type Description
list Time List List to check
Examples.
min({#19:30:15# , #11:15:20# , #13:42:23#}) = #11:15:20#
4.56. min(Timestamp List list)
Returns the minimal element of a collection
Syntax. min (Timestamp List list) : Timestamp Parameters.
Name Type Description
list Timestamp List List to check Examples.
min({#2005-05-05 19:30:15# , #2005-10-06 11:15:20# , #2005-11-15 13:42:23#}) = #2005-05-05 19:30:15.0#
4.57. minute(Time time)
Returns the value of object time in minutes.
Syntax. minute (Time time) : Integer Parameters.
Name Type Description
time Time time object
Examples.
minute(addMinutes(#19:12:07#, 10)) = 22 minute(#19:12:07#) = 12
4.58. minute(Timestamp timestamp)
Returns the minute of timestamp.
Syntax. minute (Timestamp timestamp) : Integer Parameters.
Name Type Description
timestamp Timestamp Timestamp object
Examples.
minute(#2003-02-19 19:12:07#) = 12
4.59. month(Date date)
Returns the month of date.
Syntax. month (Date date) : Integer Parameters.
Name Type Description
date Date Date
Examples.
month(#1999-12-07#) = 12 month(currentDate()) = 11 month(birthDate) BETWEEN [5, 12]
month(validDate) IN (3, 6, 9)
4.60. month(Timestamp timestamp)
Returns the month of timestamp.
Syntax. month (Timestamp timestamp) : Integer Parameters.
Name Type Description
timestamp Timestamp Timestamp object
Examples.
month(#2003-02-19 19:12:07#) = 2
4.61. nano(Timestamp timestamp)
Returns the nanosecond of timestamp.
Syntax. nano (Timestamp timestamp) : Integer Parameters.
Name Type Description
timestamp Timestamp Timestamp object
Examples.
nano(#2003-02-19 19:12:07.123456789#) = 123456789
4.62. second(Time time)
Returns the value of object time in seconds.
Syntax. second (Time time) : Integer Parameters.
Name Type Description
time Time time object
Examples.
second(addSeconds(#19:12:07#, 10)) = 17 second(#19:12:07#) = 7
4.63. second(Timestamp timestamp)
Returns the second of timestamp.
Syntax. second (Timestamp timestamp) : Integer Parameters.
Name Type Description
timestamp Timestamp Timestamp object
Examples.
second(#2003-02-19 19:12:07#) = 7
4.64. subDays(Date date, Integer days)
Subtracts the amount of days from date.
Syntax. subDays (Date date, Integer days) : Date Parameters.
Name Type Description
date Date Date to subtract days from
days Integer Amount of days to subtract from the date Examples.
date = subDays(currentDate(), 10) subDays(#1999-12-12#, 10) = #1999-12-02#
4.65. subDays(Timestamp timestamp, Integer day)
Subtracts the value of day from object timestamp.
Syntax. subDays (Timestamp timestamp, Integer day) : Timestamp Parameters.
Name Type Description
timestamp Timestamp Timestamp object from which a number of days is subtracted day Integer Number of days to be subtracted from a given timestamp object Examples.
time = subDays(currentTimestamp(), 1)
subDays(#2003-02-19 19:12:12#, 10) = #2003-02-09 19:12:12#
4.66. subHours(Time time, Integer hours)
Subtracts number of hours from object time.
Syntax. subHours (Time time, Integer hours) : Time Parameters.
Name Type Description
time Time time object from which a number of hours is subtracted hours Integer number of hours to be subtracted from a given time object Examples.
time = subHours(currentTime(), 1)
subHours(#19:12:12#, 10) = #09:12:12.000#
4.67. subHours(Timestamp timestamp, Integer hours)
Subtracts the value of hour from timestamp.
Syntax. subHours (Timestamp timestamp, Integer hours) : Timestamp Parameters.
Name Type Description
timestamp Timestamp Timestamp object from which a number of hours is subtracted hours Integer Number of hours to be subtracted from a given timestamp object Examples.
time = subHours(currentTimestamp(), 1)
subHours(#2003-02-19 19:12:12#, 10) = #2003-02-19 09:12:12#
4.68. subMillis(Time time, Integer millis)
Subtracts the given number of milliseconds from object time.
Syntax. subMillis (Time time, Integer millis) : Time Parameters.
Name Type Description
time Time time object from which a number of milliseconds is subtracted millis Integer number of milliseconds to be subtracted from a given time object Examples.
time = subMillis(currentTime(), 1) subMillis(#19:12:12#, 10) = #19:12:11.990#
4.69. subMinutes(Time time, Integer minutes)
Subtracts the given number of minutes from object time.
Syntax. subMinutes (Time time, Integer minutes) : Time Parameters.
Name Type Description
time Time time object from which a number of minutes is subtracted minutes Integer number of minutes to be subtracted from a given time object Examples.
time = subMinutes(currentTime(), 1)
subHours(#19:12:12#, 10) = #19:02:12.000#
4.70. subMinutes(Timestamp timestamp, Integer minute)
Subtracts the value of minute from timestamp.
Syntax. subMinutes (Timestamp timestamp, Integer minute) : Timestamp Parameters.
Name Type Description
timestamp Timestamp Timestamp object from which a number of minutes is subtracted minute Integer Number of minutes to be subtracted from a given timestamp object Examples.
time = subMinutes(currentTimestamp(), 1)
subMinutes(#2003-02-19 19:12:12#, 10) = #2003-02-19 19:02:12#
4.71. subMonths(Date date, Integer months)
Subtract the amount of months from date.
Syntax. subMonths (Date date, Integer months) : Date Parameters.
Name Type Description
date Date Date to subtract months from
months Integer Amount of months to be subtracted from the date Examples.
date = subMonths(currentDate(), 2) subDays(#1999-12-12#, 4) = #1999-08-02#
4.72. subMonths(Timestamp timestamp, Integer month)
Subtracts the value of month from timestamp.
Syntax. subMonths (Timestamp timestamp, Integer month) : Timestamp Parameters.
Name Type Description
timestamp Timestamp Timestamp object from which a number of months is subtracted month Integer Number of months to be subtracted from a given timestamp object Examples.
time = subMonths(currentTimestamp(), 1)
subMonths(#2003-02-19 19:12:12#, 10) = #2002-04-19 19:12:12#
4.73. subSeconds(Time time, Integer seconds)
Subtracts the given number of seconds from object time.
Syntax. subSeconds (Time time, Integer seconds) : Time Parameters.
Name Type Description
time Time time object, from which a number of seconds is subtracted seconds Integer number of seconds to be subtracted from a given time object Examples.
time = subSeconds(currentTime(), 1) subSeconds(#19:12:12#, 10) = #19:12:02.000#
4.74. subSeconds(Timestamp timestamp, Integer second)
Subtracts the value of second from timestamp.
Syntax. subSeconds (Timestamp timestamp, Integer second) : Timestamp Parameters.
Name Type Description
timestamp Timestamp Timestamp object from which a number of seconds is subtracted second Integer Number of seconds to be subtracted from a given timestamp object Examples.
time = subSeconds(currentTimestamp(), 1)
subSeconds(#2003-02-19 19:12:12#, 10) = #2003-02-19 19:12:02#
4.75. subTime(Time time1, Time time2)
Subtracts a time object from another time object.
Syntax. subTime (Time time1, Time time2) : Time Parameters.
Name Type Description
time1 Time time object from which another time object is subtracted time2 Time time object to be subtracted from another time object Examples.
time = subTime(currentTime(), #01:00:00#)
subTime(#19:12:12#, #01:01:01#) = #18:11:11.000#
4.76. subYears(Date date, Integer years)
Subtract the amount of years from date.
Syntax. subYears (Date date, Integer years) : Date Parameters.
Name Type Description
date Date Date to subtract years from
years Integer Amount of years to be subtracted from date Examples.
date = subYears(currentDate(), 2) subDays(#1999-12-12#, 4) = #1995-12-02#
4.77. subYears(Timestamp timestamp, Integer year)
Subtracts the value of year from timestamp.
Syntax. subYears (Timestamp timestamp, Integer year) : Timestamp Parameters.
Name Type Description
timestamp Timestamp Timestamp object from which a number of years is subtracted year Integer Number of years to be subtracted from a given timestamp object Examples.
time = subYears(currentTimestamp(), 1)
subYears(#2003-02-19 19:12:12#, 10) = #1993-02-19 19:12:12#
4.78. time(String text)
Converts a String with format "hh:mm:ss.fff" to a Time object. If String conversion to a Time object fails, an exception is returned.
Syntax. time (String text) : Time Parameters.
Name Type Description
text String String in time format "hh:mm:ss.fff"
text String String in time format "hh:mm:ss.fff"