CONCAT_WS ¶ definition: 'Concatenate arguments into string with separator.'

STRING_AGG(<expression>,<delimiter>) ¶ Aggregate function that builds a string by concatenating pieces.

TO_DATE(<datestring>,<formatstring>) ¶ Convert string to date.

TO_NUMBER(<numberstring>,<formatstring>) ¶ Convert string to numeric.

TO_TIMESTAMP(<datestring>,<formatstring>) ¶ Convert string to timestamp.