IBExpert UDF Functions

F_CRLF

Compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP Compatible with UTF-8 Input without Output VARCHAR(3) Carriage Return and Linefeet - produce the indications CHR(13) + CHR(10)

F_LF function from adhoc compatible with UTF-8 Input without Output VARCHAR(2) Linefeet - produce the indications CHR(10) Identically to F_CHARACTER(10)

'''F_SPACE compatibility to GrUDF compatible with UTF-8 Input INTEGER number of blanks Output VARCHAR(32760) blank chain (CHR(32)) with indicated numbers

F_DQM function from adhoc compatible with UTF-8 Input without Output VARCHAR(2) double-quote-mark CHR(34) Identically to F_CHARACTER(34).

F_SQM function from adhoc compatible with UTF-8 Input without Output VARCHAR(2) single-quote-mark CHR(39) Identically to F_CHARACTER(39).

F_DSQM function from adhoc compatible with UTF-8 Input without Output VARCHAR(2) 2 single-quote-marks CHR(39)

F_TAB function from adhoc compatible with UTF-8 Input without Output VARCHAR(2) Tabulator CHR(9) Identically to F_CHARACTER(9).

F_LEFT (F_LEFT4, F_LEFT8) F_BIGLEFT compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF not compatible with UTF-8 - use U_LEFT(U_LEFT4, U_LEFT8) U_LEFT (U_LEFT4, U_LEFT8) function from adhoc compatible with UTF-8 Input VARCHAR(254) string, INTEGER length of the cut-off-string Output VARCHAR(254) string cut on the number indication from left gives from parameter 2 Counting starts with 1

F_MID (F_MID4, F_MID8) F_BIGMID compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP not compatible with UTF-8 - use U_MID(U_MID4, U_MID8) U_MID (U_MID4, U_MID8) function from adhoc compatible with UTF-8 F_COPY compatibility to GrUDF not compatible with UTF-8 - use U_MID(U_MID4, U_MID8) F_STRCOPY input/output-compatibility to rFunc (SUBSTR, LONGSUBSTR) not compatible with UTF-8 - use U_MID(U_MID4, U_MID8)''' Input VARCHAR(254) String, from which a character string is to be determined, INTEGER Startposition of the string, INTEGER Length of the string Output VARCHAR(254) string starts at position form parameter 2 with the lenght of parameter 3 For F_MID and F_STRCOPY counting of parameter 2 start with 0, for F_COPY with 1!

F_RIGHT (F_RIGHT4, F_RIGHT8) F_BIGRIGHT compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF not compatible with UTF-8 - use U_RIGHT(U_RIGHT4, U_RIGHT8) U_RIGHT (U_RIGHT4, U_RIGHT8) function from adhoc compatible with UTF-8 Input VARCHAR(254) String, INTEGER length of the cut-off-string Output VARCHAR(254) string cut on the number indication from right gives from parameter 2 Counting starts with 1

F_SUBSTR (F_SUBSTR4, F_SUBSTR8) F_BIGSUBSTR compatibility to FreeUDFLibC not compatible with UTF-8 - use U_SUBSTR Input VARCHAR(8190) String 1 (in which the position of parameter 2 is to be determin), VARCHAR(1024) String 2 (to be determin) Output INTEGER first position in string 1 where string 2 starts F_STRSUB compatibility to FreeUDFLib, FreeUDFLib AvERP, GrUDF not compatible with UTF-8 - use U_SUBSTR F_STRPOS input/output-compatibility to rFunc (STRPOS) not compatible with UTF-8 - use U_SUBSTR Input VARCHAR(1024) String 1 (to be determin), VARCHAR(8190) String 2 (in which the position of parameter 2 is to be determin) Output INTEGER first position in string 1 where string 2 starts F_SUBSTR, F_STRSUB etc.: Counting starts with 0, if not found -1. F_STRPOS: Counting starts with 1, if not found 0.

F_SUBSTRN (F_SUBSTR) function from adhoc not compatible with UTF-8 - use U_SUBSTR U_SUBSTR function from adhoc compatible with UTF-8 Input VARCHAR(8190) String 1 (in which the position of parameter 2 is to be determin), VARCHAR(1024) String 2 (to be determin) Output INTEGER first position in string 1 where string 2 starts F_STRSUBN function from adhoc not compatible with UTF-8 - use U_SUBSTR Input VARCHAR(1024) String 1 (to be determin), VARCHAR(8190) String 2 (in which the position of parameter 2 is to be determin) Output INTEGER first position in string 2 where string 1 starts The formerly functions (F_SUBSTR and F_STRSUB) return -1 if the string is not found.

F_STRRM compatibility to ??? not compatible with UTF-8 - use U_STRRM U_STRRM function from adhoc compatible with UTF-8 Input VARCHAR(8190) where a character string had to be remove, INTEGER String Place in the string, which is to be removed Output VARCHAR(8190) string with the removed string counting starts with 0

F_LTRIM (F_LTRIM4, F_LTRIM8) F_BIGLTRIM compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF input/output-compatibility to rFunc ( LTRIM, LONGLTRIM) compatible with UTF-8 Input VARCHAR(8190) String whose leeding blanks should be removed Output VARCHAR(8190) String without leeding blanks Does not remove the protected blanks (with < ALT > < 255 >)

F_RTRIM (F_RTRIM4, F_RTRIM8) F_BIGRTRIM compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF input/output-compatibility to rFunc ( RTRIM, LONGRTRIM) compatible with UTF-8 Input VARCHAR(8190) String whose trailing blanks should be removed Output VARCHAR(8190) String without trailing blanks Does not remove the protected blanks (with < ALT > < 255 >)

F_LRTRIM (F_LRTRIM4, F_LRTRIM8) F_BIGLRTRIM compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF input/output-compatibility to rFunc (TRIM, LONGTRIM) compatible with UTF-8 Input VARCHAR(8190) String whose leeding and trailing blanks should be removed Output VARCHAR(8190) String without leeding and trailing blanks Does not remove the protected blanks (with < ALT > < 255 >)

F_PADLEFT compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF not compatible with UTF-8 - use U_PADLEFT U_PADLEFT function from adhoc compatible with UTF-8 Input VARCHAR(4095) String 1, filled up left with the indications from string 2 to the length of parameter 3, VARCHAR(16) String 2 to fill up with, INTEGER Length of the string, up to which is to be filled up Output VARCHAR(4095) String 1 left filled up from the string with the indications from string 2 to the overall length of indications of parameter 3 F_RPADLEFT input/output-compatibility to rFunc (PADLEFT, LONGPADLEFT) not compatible with UTF-8 - use U_PADLEFT Input VARCHAR(4095) String 1, filled up left with the indications from string 2 to the length of parameter 3, INTEGER Length of the string, up to which is to be filled up, VARCHAR(16) String 2 to fill up with Output VARCHAR(4095) String 1 left filled up from the string with the indications from string 2 to the overall length of indications of parameter 3 If you enter more than one character in string 2, the filling with characters of string 2 starts from right and abort, if the required number of the complete characters will be reached.

F_PADRIGHT compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF not compatible with UTF-8 - use U_PADRIGHT U_PADRIGHT function from adhoc compatible with UTF-8 Input VARCHAR(4095) String 1, filled up right with the indications from string 2 to the length of parameter 3, VARCHAR(16) String 2 to fill up with, INTEGER Length of the string, up to which is to be filled up Output VARCHAR(4095) String 1 right filled up from the string with the indications from string 2 to the overall length of indications of parameter 3 F_RPADRIGHT input/output-compatibility to rFunc (PADRIGHT, LONGPADRIGHT) not compatible with UTF-8 - use U_PADRIGHT Input VARCHAR(4095) String 1, filled up right with the indications from string 2 to the length of parameter 3, INTEGER Length of the string, up to which is to be filled up, VARCHAR(16) String 2 to fill up with Output VARCHAR(4095) If you enter more than one character in string 2, the filling with characters of string 2 starts from right and abort, if the required number of the complete characters will be reached.

F_PADCENTER function from adhoc not compatible with UTF-8 - use U_PADCENTER U_PADCENTER function from adhoc compatible with UTF-8 Input VARCHAR(4095) String 1, filled up with the indications from string 2 to the length of parameter 3, VARCHAR(16) String 2 to fill up with, INTEGER Length of the string, up to which is to be filled up Output VARCHAR(4095) String 1 left and right filled up from the string with the indications from string 2 to the overall length of indications of parameter 3 If the "filled-length" is not eval, there is one more character filled up left

F_LINEWRAP compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF not compatible with UTF-8 - use U_LINEWRAP U_LINEWRAP function from adhoc compatible with UTF-8 Input VARCHAR(32760) String, INTEGER starting position, INTEGER measure Output VARCHAR(32760)Spends all words of the string, begin with the initial position, which are all not longer than the measure. Counting starts with 0.

F_REPLACE (F_REPLACE4, ...8) F_BIGREPLACE compatibility to FreeUDFLibC compatible with UTF-8 Input VARCHAR(32760) string where a character string had to be exchanged, VARCHAR(254) old string, VARCHAR(254) new string Output VARCHAR(32760) string with replaced characters from parameter 2 with characters from parameter 3 Easy version of the function F_REPLACESTRING without the posibility to change the string more than one time and independent of upper and lower case.

F_REPLACESTRING (..4, ..8) F_BIGREPLACESTRING compatibility to FreeUDFLib AvERP, GrUDF not compatible with UTF-8 - use U_REPLACESTRING U_REPLACESTRING (..4, ..8) function from adhoc compatible with UTF-8 Input VARCHAR(32760) string where a character string had to be exchanged, VARCHAR(254) old string, VARCHAR(254) new string, INTEGER 0 = replace only the first occurrence, 1 = replace all occurrences, INTEGER 0 = consider upper and lower case, 1 = not consider Output VARCHAR(32760) string with replaced characters from parameter 2 with characters from parameter 3

F_CONVERTSYMBOLS input/output-compatibility to rFunc (CONVERTSYMBOLS, LONGCONVERTSYMBOLS) not compatible with UTF-8 - use U_CONVERTSYMBOL U_CONVERTSYMBOLS function from adhoc compatible with UTF-8 Input VARCHAR(32760) String in which characters should be replaced, VARCHAR(254) String 2 with all characters to be replaced, VARCHAR(254) String 3 with characters to replace with characters at the same place in string 2 Output VARCHAR(32760) String in which all characters where replaced with characters from string 3

F_REVERSE function from adhoc not compatible with UTF-8 - use U_REVERSE U_REVERSE function from adhoc compatible with UTF-8 Input VARCHAR(254) string to return backwards Output VARCHAR(254) string backwards Upper-/lower-case stays as in the original string.

F_STRIPSTRING F_BIGSTRIPSTRING compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF not compatible with UTF-8 - use U_STRIPSTRING F_STRIPSTRING function from adhoc compatible with UTF-8 Input VARCHAR(32760) String 1, VARCHAR(254) String 2 as a list of all characters which are to delete Output VARCHAR(32760) String stripped from all characters which are content of parameter 2 Counterpart to F_STRIPSTRINGHOLD and F_HOLDSTRING

F_STRIPSTRINGHOL F_HOLDSTRING F_BIGSTRIPSTRINGHOLD compatibility to FreeUDFLib, FreeUDFLib AvERP, GrUDF compatibility to FreeUDFLibC not compatible with UTF-8 - use U_STRIPSTRINGHOLD U_STRIPSTRINGHOLD function from adhoc compatible with UTF-8 Input VARCHAR(32760) String 1, VARCHAR(254) String 2 as a list of all characters which are not to delete Output VARCHAR(32760) String stripped from all characters which are not content of parameter 2 The sequence of the indications in the string 2 does not matter. Counterpart to F_STRIPSTRING Note: In a SQL F_HOLDSTRING and F_STRIPSTRINGHOLD may not use at the same time.

F_REPEATTRIM input/output-compatibility to rFunc (REPEATTRIM, LONGREPEATTRIM) not compatible with UTF-8 - use U_REPEATTRIM U_REPEATTRIM compatible with UTF-8 Input VARCHAR(8190) String 1 from which characters will be removed, VARCHAR(1) character to remove Output VARCHAR(8190) String with removed all repeatings of characters parameter 2

F_STRREPEAT input/output-compatibility to rFunc (STRREPEAT, LONGSTRREPEAT) compatible with UTF-8 Input VARCHAR(254) String to repeat, SMALLINT count of appearance Output VARCHAR(8190) String 1 with parameter 2 times appearances You have to look that the output is not greater than the declaration!

F_STROFCHAR compatibility to GrUDF not compatible with UTF-8 - use F_STRREPEAT Input VARCHAR(1) String to repeat, INTEGER Number of repetitions Output VARCHAR(32760) Returns a string with the indicated number of repeated indications

F_STRSTUFF input/output-compatibility to rFunc (STRSTUFF, LONGSTRSTUFF) not compatible with UTF-8 - use U_STRSTUFF U_STRSTUFF function from adhoc compatible with UTF-8 Input VARCHAR(8190) String 1 in which characters had to replace, SMALLINT starting-position, SMALLINT number of characters to delete, VARCHAR(254) characters to set Output VARCHAR(81900) String with replaced characters at starting-postion Counting oof starting-position starts at 1. The numbers of characters to delete and characters to replace must not be equal.

F_COLLATEBR TO-DO

F_KEYUP TO-DO

F_PRED function from adhoc not compatible with UTF-8 - use U_PRED U_PRED function from adhoc compatible with UTF-8 Input VARCHAR(1) Character, INTEGER Amount of characters before the character in ASCII-Table Output VARCHAR(1) n-predecessor of character from parameter 1 Is parameter 2 equal to 512 (or multiple of 512) the return is the same as the input. U_PRED ignores UTF8 chars

F_SUCC function from adhoc not compatible with UTF-8 - use U_SUCC U_SUCC function from adhoc compatible with UTF-8 Input VARCHAR(1) Character, INTEGER Amount of characters behind the character in ASCII-Table Output VARCHAR(1) n-successor of character from parameter 1 Is parameter 2 equal to 512 (or multiple of 512) the return is the same as the input. U_SUCC function from adhoc

F_LOWER, F_ANSILOWERCASE function from adhoc compatibility to FreeUDFLib AvERP, GrUDF not compatible with UTF-8 - use U_LOWER U_LOWER function from adhoc compatible with UTF-8 Input VARCHAR(32760) String to convert Output VARCHAR(32760) String with all characters as lower incl. umlaut

F_UPPER function from adhoc F_ANSIUPPERCASE compatibility to FreeUDFLib AvERP, GrUDF not compatible with UTF-8 - use U_UPPER U_UPPER function from adhoc compatible with UTF-8 Input VARCHAR(32760) String to convert Output VARCHAR(32760) String with all characters as upper incl. umlaut

F_RLOWER cyrillic F_RUPPER cyrillic F_RLATIN only for charset Win1251 U_CYRILLIC_LATIN TO-DO

F_PROPERCASE compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF not compatible with UTF-8 - use U_PROPERCASE U_PROPERCASE function from adhoc compatible with UTF-8 Input VARCHAR(32760) String to convert Output VARCHAR(32760) String with all words starting with upper, all other lower Changes also umlaut. A lower "�" stays "�" because there is no upper "�"

F_CHARACTER compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP F_CHR compatibility to GrUDF input/output-compatibility to rFunc (CHR) not compatible with UTF-8 - use U_CHR U_CHR function from adhoc compatible with UTF-8 Input INTEGER ASCII-Code Output VARCHAR(2) Character of ASCII-Codes U_CHR raises exception for UTF8

F_ORD input/output-compatibility to rFunc (ORD) not compatible with UTF-8 - use U_ORD U_ORD function from adhoc compatible with UTF-8 Input VARCHAR(1) ASCII-Code-No. Output SMALLINT Character of ASCII-Code-No.

F_ROT13 function from adhoc compatible with UTF-8 Input VARCHAR(254) String to encrypt Output VARCHAR(254) String enrypted with ROT13 From Wikipedia: ROT13 ("rotate by 13 places", sometimes hyphenated ROT-13) is a simple substitution cipher used in online forums as a means of hiding spoilers, punchlines, puzzle solutions, and offensive materials from the casual glance. ROT13 has been described as the "Usenet equivalent of a magazine printing the answer to a quiz upside down". ROT13 is a variation of the Caesar cipher, developed in ancient Rome. Applying ROT13 to a piece of text merely requires examining its alphabetic characters and replacing each one by the letter 13 places further along in the alphabet, wrapping back to the beginning if necessary. ROT13 is its own inverse; that is, to undo ROT13, the same algorithm is applied, so the same action can be used for encoding and decoding. The algorithm provides no real cryptographic security and is not normally used for such. It is often cited as a canonical example of weak encryption.

F_GENERATESNDXINDEX compatibility to FreeUDFLib, FreeUDFLib AvERP F_SOUNDEX function from adhoc Input VARCHAR(8190) String to generate Soundex Output VARCHAR(6) original (american) soundex of string Soundex is a phonetic algorithm to indexation of words and cliches after its sound in the English language. Equalequivalent words are to be coded thereby to an identical character sequence. Considered starting from the 2. place counted only the first 6 consonants with the determination, whereby repeated occurrence is only once considered (in the example the l,m,y,w,r,d). Therefore it is unsuitable, around longer strings to compare.

F_GSOUNDEX TO-DO

F_TELEFONNR function from adhoc Input VARCHAR(32760) Telephone no. as string (or something similar, from which everything is to be removed up to the numbers), INTEGER defines the amount of numbers at the end to replace with * Output VARCHAR(32760)String without all non numbers "49" at the beginning is changed to "+49". If the string starts with one "+", this remains. Note: This function is necessary for "wildly" formatted telephonenumbers for TAPI to a Telephone(system) which couldn't do this by itsself.

F_DIGITS compatibility to GrUDF compatible with UTF-8 Input VARCHAR(32760) String from which all non-numbers had to be remove Output VARCHAR(32760) String with removed all non-numbers (e.g. for TAPI)

F_STR2EXCEL function from adhoc Input VARCHAR(32760) String Output VARCHAR(32760) String changed for Excel To convert multiline texts and texts with converted commas to Excel, it is required to transform the string. This function will do the following: - appends a double inverted comma at the beginning and the end of the string - doubles all inverted commas - deletes all CHR(13) in the string - limits the input string to 8190characters (Limitation in FB UTF8)

F_RC input/output-compatibility to rFunc ( C, LONGC) compatible with UTF-8 Input VARCHAR(254) String Output VARCHAR(254) is input-string <null> returns an empty string, either the input-string

F_FLOATOSTR TO-DO F_INTTOSTR TO-DO

F_EQUALSTRING compatibility to FreeUDFLib AvERP, GrUDF input/output-compatibility to rFunc (CEQUAL) compatible with UTF-8 Input VARCHAR(8190) String 1, VARCHAR(8190) String 2 Output INTEGER 1 = is equal, 0 = is not equal

F_STRCMP input/output-compatibility to rFunc (STRCMP) not compatible with UTF-8 - use U_STRCMP U_STRCMP function from adhoc compatible with UTF-8 Input VARCHAR(8190) String 1, VARCHAR(8190) String 2 Output INTEGER output < 0 : string 1 smaller than string 2, output = 0 : string 1 equal to string 2, output > 0 : string 1 greater than string 2 Attention: in original rFunc-functions STRCMP the output positiv or negativ is different to the rFunc-BLOb-function B_STRCMP - in string-function a positiv output meens, that the first string is greater, in BLOb-function it meens, that the second BLOb is greater. For compatibility reasons the FreeAdhocUDF do exactly the same. In Linux (NEED TO CHECK, it might be) the value of output is other than in Windows!

F_FINDWORD compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP not compatible with UTF-8 - use U_FINDWORD U_FINDWORD function from adhoc compatible with UTF-8 Input VARCHAR(32760) String, in which another string is to be looked for, INTEGER Position, at which the search in the string should starts Output VARCHAR(254) word or a partial word , which starts at positon parameter 2 Positioning starts with 0, that means 1.position = 0 and searches up to the first blank. returns <null> if parameter 2 < 0 or > length of parameter 1, all other cases '' (empty string).

F_WORDNUM input/output-compatibility to rFunc (WORDNUM, LONGWORDNUM) Input VARCHAR(32760) string, in which an other string is looked for, INTEGER no. of string to find (n-ths word), VARCHAR(31) word delimiter, SMALLINT ??? Output VARCHAR(254) nth-word Counting for parameter 2 starts with 1.

F_FINDNTHWORD compatibility to FreeUDFLib, FreeUDFLib AvERP Input VARCHAR(32760) string, in which an other string is looked for, INTEGER no. of string to find (n-ths word) Output VARCHAR(254) nth-word Counting starts at 0.

F_FINDWORDINDEX compatibility to FreeUDFLib, FreeUDFLib AvERP Input VARCHAR(32760) String, INTEGER length of the string which should be examined Output INTEGER examines whether the position from Paramter 2 exists in the string. If the position is found in the string, the result is the position itself, if not found the result is -1. Counting starts at 0.

F_FINDWORDINDEXN (F_FINDWORDINDEX) function from adhoc Input VARCHAR(32760) String, INTEGER length of the string which should be examined Output INTEGER examines whether the position from Paramter 2 exists in the string. If the position is found in the string, the result is the position itself, if not found the result is <null>. Counting starts at 0.

F_STRINGLENGTH (..4, ..8, ..32) compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF F_BIGSTRINGLENGTH input/output-compatibility to rFunc (STRLEN) not compatible with UTF-8 - use U_STRINGLENGTH U_STRINGLENGTH (..4, ..8, ..32) function from adhoc compatible with UTF-8 Input VARCHAR(32760) String Output INTEGER Determines the length of a string, considers also simple blanks at the end F_STRINGLENGTH and F_BIGSTRINGLENGTH are not allowed in one SQL.

F_STRINGLISTITEM compatibility to GrUDF compatible with UTF-8 Input VARCHAR(32760) stringlist formatted like �n=..�,�m=..�, a.s.o., VARCHAR(254) Value from the list to be shown Output VARCHAR(1024) Searchs the string, build a stringlist (Name=Value) for the Name and returns the complete Name=Value DOESN'T LIKE UMLAUT in UTF8 db

F_WORDCOUNT function from adhoc compatible with UTF-8 Input VARCHAR(32760) String in which the amount of words are to be calculated Output INTEGER amount of words in the string A word ends with one ore more spaces, TAB or CRLF.

F_RWORDCOUNT input/output-compatibility to rFunc (WORDCOUNT) Input VARCHAR(32760) String, VARCHAR(31) word delimiter, SMALLINT Output INTEGER number of words

F_STRINGCOUNT function from adhoc compatible with UTF-8 Input VARCHAR(32760) String1,VARCHAR(254) String2 Output INTEGER Amount of String 2 in String 1 F_RSTRINGCOUNT input/output-compatibility to rFunc (STRINGCOUNT) compatible with UTF-8 Input VARCHAR(254) String 1, VARCHAR(32760) String 2 Output INTEGER Amount of String 1 in String 2

F_DOMAINFROMEMAIL function from adhoc compatible with UTF-8 Input VARCHAR(254) eMail-String Output VARCHAR(254) from eMail substituted domain

F_ADDYEAR compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF compatible with UTF-8 Input TIMESTAMP date optionally time, INTEGER years to add Output TIMESTAMP adds years to timestamp If parameter 2 is negative, years to subtract. If the outputyear is a non-leapyear, for input 29th February the output is 1st March.

F_ADDMONTH compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF compatible with UTF-8 Input TIMESTAMP date optionally time, INTEGER month to add Output TIMESTAMP adds months to timestamp If parameter 2 is negative, months to subtract.

F_ADDWEEK function from adhoc compatible with UTF-8 Input TIMESTAMP date optionally time, INTEGER weeks to add Output TIMESTAMP adds weeks to timestamp If parameter 2 is negative, weeks to subtract.

F_ADDDAY function from adhoc compatible with UTF-8 Input TIMESTAMP date optionally time, INTEGER days to add Output TIMESTAMP adds days to timestamp If parameter 2 is negative, days to subtract.

F_ADDHOUR function from adhoc compatible with UTF-8 Input TIMESTAMP date optionally time, INTEGER hours to add Output TIMESTAMP adds hours to timestamp If parameter 2 is negative, hours to subtract.

F_ADDMINUTE function from adhoc compatible with UTF-8 Input TIMESTAMP date optionally time, INTEGER minutes to add Output TIMESTAMP adds minutes to timestamp If parameter 2 is negative, minutes to subtract.

F_ADDSECOND function from adhoc compatible with UTF-8 Input TIMESTAMP date optionally time, INTEGER seconds to add Output TIMESTAMP adds seconds to timestamp If parameter 2 is negative, seconds to subtract.

F_INCDATE input/output-compatibility to rFunc (INCDATE) compatible with UTF-8 Input TIMESTAMP date optionally time, INTEGER days to add, INTEGER month to add, INTEGER years to add Output TIMESTAMP Adds to parameter 1 days, month and years. If parameters are negative they will be subtracted.

F_INCDATETIME input/output-compatibility to rFunc (INCDATETIME) compatible with UTF-8 Input TIMESTAMP date optionally time, INTEGER days to add, INTEGER month to add, INTEGER years to add, INTEGER hours to add, INTEGER minutes to add, INTEGER seconds to add Output TIMESTAMP Adds to parameter 1 days, month, years, hours, minutes and seconds. If parameters are negative they will be subtracted.

F_ADDPERIOD function from adhoc compatible with UTF-8 Input VARCHAR(254) period 1 in pattern [d]:h:m:s, VARCHAR(254) period 2 in pattern [d]:h:m:s Output VARCHAR(254) sum of period 1 and 2 Periods could be enter with 2- or 1digits interval (dd:hh:mm:ss or d:h:m:s). Negative periods starts with a "-" in front. Periods with pattern days:hours:minutes:seconds (4 intervalls) or hours:minutes:seconds (3 intervalls) are allowed. The output of periods with less than 3 intervalls or containing other characters is <null> or empty string. For input also f.e. '0:26:0:0' instead of '1:2:0:0' alllowed for 26 hours. The output is allways in pattern days:hours:minutes:seconds (4 * 2 digit intervalls)

F_SUBPERIOD function from adhoc compatible with UTF-8 Input VARCHAR(254) period 1 in pattern [d]:h:m:s, VARCHAR(254) period 2 in pattern [d]:h:m:s Output VARCHAR(254) period 2 subtracted from period 1 Periods could be enter with 2- or 1digits interval (dd:hh:mm:ss or d:h:m:s). Negative periods starts with a "-" in front. Periods with pattern days:hours:minutes:seconds (4 intervalls) or hours:minutes:seconds (3 intervalls) are allowed. The output of periods with less than 3 intervalls or containing other characters is <null> or empty string. For input also f.e. '0:26:0:0' instead of '1:2:0:0' alllowed for 26 hours. The output is allways in pattern days:hours:minutes:seconds (4 * 2 digit intervalls). If second input period is greater than first, the output is negativ ("-" in front).

F_AGEINYEARS function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) years between timestamp 1 and timestamp 2

F_AGEINYEARSN function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) years between timestamp 1 and timestamp 2

F_AGEINMONTHS compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) months between timestamp 1 and timestamp 2

F_AGEINMONTHSN function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) months between timestamp 1 and timestamp 2

F_AGEINWEEKS compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) weeks between timestamp 1 and timestamp 2 Sunday is 1st day of week. If the two dates are in the same week, the return value is 0.

F_AGEINWEEKSISO function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) weeks between timestamp 1 and timestamp 2 ISO-version of F_AGEINWEEKS. Monday is 1st day of week. If the two dates are in the same week, the return value is 0.

F_AGEINWEEKSN function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) weeks between timestamp 1 and timestamp 2 Sunday is 1st day of week. If the two dates are in the same week, the return value is 0

F_AGEINWEEKSNISO function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) weeks between timestamp 1 and timestamp 2 ISO-version of F_AGEINWEEKSN. Monday is 1st day of week. If the two dates are in the same week, the return value is 0.

F_AGEINDAYS function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) days between timestamp 1 and timestamp 2

F_AGEINDAYSN function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) days between timestamp 1 and timestamp 2

F_AGEINWORKINGDAYS function from adhoc Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2, INTEGER weekday don't calculate Output INTEGER difference in (integer) days between timestamp 1 and timestamp 2 less of weekday/s from param 3 weekday: Monday = 1, Thuesday = 2, Wednesday = 3, Thursday = 4, Friday = 5, Saturday = 6, Sunday = 7 If 1st date is newer than 2nd date, the result is negativ. Any order of indexes for weekdays. Only allowed indexes are calculated.

F_AGEINHOURS function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) hours between timestamp 1 and timestamp 2

F_AGEINHOURSN function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) hours between timestamp 1 and timestamp 2

F_AGEINMINUTES function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) minutes between timestamp 1 and timestamp 2

F_AGEINMINUTESN function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) minutes between timestamp 1 and timestamp 2

F_AGEINSECONDS function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) seconds between timestamp 1 and timestamp 2

F_AGEINSECONDSN function from adhoc compatible with UTF-8 Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2 Output INTEGER difference in (integer) seconds between timestamp 1 and timestamp 2

F_AGEINYEARSTHRESHOLD function from adhoc Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2, INTEGER min. value, INTEGER min. value is used (0 = no, 1 = yes), INTEGER max. value, INTEGER max. value is used (0 = no, 1 = yes) Output INTEGER difference in (integer) years between timestamp 1 and timestamp 2

F_AGEINMONTHSTHRESHOLDN function from adhoc Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2, INTEGER min. value, INTEGER min. value is used (0 = no, 1 = yes), INTEGER max. value, INTEGER max. value is used (0 = no, 1 = yes) Output INTEGER difference in (integer) months between timestamp 1 and timestamp 2

F_AGEINWEEKSTHRESHOLD function from adhoc Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2, INTEGER min. value, INTEGER min. value is used (0 = no, 1 = yes), INTEGER max. value, INTEGER max. value is used (0 = no, 1 = yes) Output INTEGER difference in (integer) weeks between timestamp 1 and timestamp 2 Sunday is 1st day of week. If the two dates are in the same week, the return value is 0.

F_AGEINWEEKSTHRESHOLDISO function from adhoc Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2, INTEGER min. value, INTEGER min. value is used (0 = no, 1 = yes), INTEGER max. value, INTEGER max. value is used (0 = no, 1 = yes) Output INTEGER difference in (integer) weeks between timestamp 1 and timestamp 2 ISO-version of F_AGEINWEEKSTHRESDHOLD. Monday is 1st day of week. If the two dates are in the same week, the return value is 0.

F_AGEINWEEKSTHRESHOLDN function from adhoc Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2, INTEGER min. value, INTEGER min. value is used (0 = no, 1 = yes), INTEGER max. value, INTEGER max. value is used (0 = no, 1 = yes) Output INTEGER difference in (integer) weeks between timestamp 1 and timestamp 2 Sunday is 1st day of week. If the two dates are in the same week, the return value is 0.

F_AGEINWEEKSTHRESHOLDNISO function from adhoc Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2, INTEGER min. value, INTEGER min. value is used (0 = no, 1 = yes), INTEGER max. value, INTEGER max. value is used (0 = no, 1 = yes) Output INTEGER difference in (integer) weeks between timestamp 1 and timestamp 2 ISO-version of F_AGEINWEEKSTHRESDHOLDN. Monday is 1st day of week. If the two dates are in the same week, the return value is 0.

F_AGEINDAYSTHRESHOLD compatibility to FreeUDFLib, FreeUDFLib AvERP Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2, INTEGER min. value, INTEGER min. value is used (0 = no, 1 = yes), INTEGER max. value, INTEGER max. value is used (0 = no, 1 = yes) Output INTEGER difference in (integer) days between timestamp 1 and timestamp 2

F_AGEINDAYSTHRESHOLDN function from adhoc Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2, INTEGER min. value, INTEGER min. value is used (0 = no, 1 = yes), INTEGER max. value, INTEGER max. value is used (0 = no, 1 = yes) Output INTEGER difference in (integer) days between timestamp 1 and timestamp 2

F_AGEINWORKINGDAYSTHR function from adhoc Input TIMESTAMP (older) date optionally time 1, TIMESTAMP (newer) date optionally time 2, INTEGER min. value, INTEGER min. value is used (0 = no, 1 = yes), INTEGER max. value, INTEGER max. value is used (0 = no, 1 = yes), INTEGER weekday don't calculate Output INTEGER difference in (integer) days between timestamp 1 and timestamp 2 less of weekday/s from param 7 weekday: Monday = 1, Thuesday = 2, Wednesday = 3, Thursday = 4, Friday = 5, Saturday = 6, Sunday = 7 If 1st date is newer than 2nd date, the result is negativ. Any order of indexes for weekdays. Only allowed indexes are calculated.

Search

German

Follow IBExpertise on:

edit SideBar

legal - website privacy policy
� Copyright IBExpert Ltd 2002-2026
Page last modified on December 10, 2018, at 01:02 PM MEZ

the database experts

IBExpert UDF Functions

IBExpert UDF Functions

F_CRLF

Search