如何在Spark SQL中格式化日期？

import org.apache.spark.sql.functions._

val df = spark.createDataFrame(Seq(
  (1, "2022-01-01"),
  (2, "2022-02-01"),
  (3, "2022-03-01")
)).toDF("id", "date")

val formattedDF = df.withColumn("formatted_date", date_format(col("date"), "yyyy/MM/dd"))

formattedDF.show()

+---+----------+--------------+
|id |date      |formatted_date|
+---+----------+--------------+
|1  |2022-01-01|2022/01/01    |
|2  |2022-02-01|2022/02/01    |
|3  |2022-03-01|2022/03/01    |
+---+----------+--------------+