Function returns the formatted string by given format and arguments.

Function takes following parameters:

Type

Field

string / varchar

Format to apply.

any or array

Arguments to use with given format.

Can be use as single value:

AUX.FUNCTION('some-format', singlevalue)

Or array like value

AUX.FUNCTION('some-format', ARRAY[firstvalue, secondvalue,...])

Examples

SELECT
	id, created,
	AUX.FORMAT('%010d', id) AS formatted_id,
	AUX.FORMAT('%tc', created) AS formatted_created,
	AUX.FORMAT('%010d  --- %tc', ARRAY[id, created]) formatted_both
FROM core.issues
LIMIT 4

Function FORMAT

Examples