CONCAT_WS
Learn how to use the CONCAT_WS string function in PlaidCloud Lakehouse. Concatenates strings with a separator - see syntax, examples, and output.
Concatenates strings with a separator.
Analyze Syntax
func.concat_ws(<sep>, <str1>, <str2>[, ...])
Analyze Examples
func.concat_ws('-', '2024', '01', '15')
┌──────────────┐
│ '2024-01-15' │
└──────────────┘
SQL Syntax
CONCAT_WS(<sep>, <str1>, <str2>[, ...])
SQL Examples
SELECT CONCAT_WS('-', '2024', '01', '15');
┌────────────┐
│ 2024-01-15 │
└────────────┘