FORMAT

FORMAT(value, format AS STRING) AS STRING

Returns a formatted string for the parameter <value>, depending on the parameter <format>.

<value> of STRING type:

• ">" : conversion to upper case
• "<" : conversion to lower case

<value> of numerical type:

• Format compatible with the C-function sprintf

<value> of TIME type:

• dd or d : numerical day with or without 0
• mm or m : numerical month with or without 0
• yy or yyyy : year with 2 or 4 digits
• hh or h : hours with or without 0
• nn or n : minutes with or without 0
• ss or s : seconds with or without 0
• zzz or z : milliseconds with or without 0
• fs Windows : formatted date (short format)
• fl Windows : formatted date (long format)
• ft Windows : formatted time