Returns the nth (from 1 to n) line of the string Returns the number of characters in a string Returns the position of string 2 in string 1 Returns the character corresponding to the 'n' ASCII code Returns the ASCII value of the first character in the string Indicates if all parameters are non-null and not empty The string functions are used to manipulate a set of strings. Otherwise, returns value 2 (may only be used as a parameter of the case function) Returns value 1 if the expression is verified. Returns the empty string if the argument is NULL Returns value 2 if the string is empty, otherwise returns value 3 Indicates whether the Flag is in the value Returns value 1 if the expression is true, otherwise returns value 2 Retrieves the URL of the mirror page server Returns value 1 (may only be used as a parameter of the case function)Įxtracts the domain from an email address Returns value 3 is value 1 = value 2, otherwise returns 4 Returns value 2 if value 1 is zero or null, otherwise returns value 1 Returns value 1 if the condition is verified. This table contains the remaining functions available. Returns the ratio of two numbers expressed as a percentage Returns the remainder of the integer division from n1 by n2 Returns the greatest integer lower than or equal to a number Returns the lowest integer greater than or equal to a number The numerical value functions are used to convert text to numbers. Returns the distance in kilometers between two points defined by their longitude and latitude (expressed in degrees) The geomarketing functions are used to manipulate geographical values. Returns the number of years between the two dates Returns the number representing the year and month of the date Returns the number representing the year of the date Returns the number representing the day in the week of the date Rounds a date + time to January 1st of the year Rounds the time part up to the nearest second Rounds a date + time to a given precision expressed in seconds Subtracts a number of seconds from a dateĮxample: ToDateTimeWithTimezone (" 08:09:00", "Asia/Tehran") Subtracts a number of minutes from a date Returns the number of seconds between two dates Returns the number of months between two dates Returns the date corresponding to the current date minus n months Returns the number representing the month of the date Returns the number of minutes between two dates Returns the number of hours between two dates Returns the current system date of the server Returns the current date minus n days (as an integer yyyymmdd) Returns a number representing the day in the year of the date Returns the number representing the day of the date Returns the date only (with time at 00:00) The date functions are used to manipulate date or time values. Additional functions are available in all the activities that allow you to use events variables after calling a workflow with external parameters.
0 kommentar(er)
