fix: Support scalar inputs for datetime expressions when constant folding is disabled #5399

Job	Run time
Lint	32s
Build Native Library (macOS)	2m 48s
macos-14/Spark 3.5, JDK 17, Scala 2.13 [parquet]	16m 33s
macos-14/Spark 3.5, JDK 17, Scala 2.13 [sql]	11m 15s
macos-14/Spark 4.0, JDK 17, Scala 2.13 [exec]	21m 29s
macos-14/Spark 4.0, JDK 17, Scala 2.13 [csv]	9m 21s
macos-14/Spark 3.5, JDK 17, Scala 2.13 [fuzz]	23m 38s
macos-14/Spark 4.0, JDK 17, Scala 2.13 [expressions]	20m 46s
macos-14/Spark 4.0, JDK 17, Scala 2.13 [parquet]	18m 46s
macos-14/Spark 4.0, JDK 17, Scala 2.13 [sql]	12m 42s
macos-14/Spark 3.5, JDK 17, Scala 2.13 [exec]	19m 13s
macos-14/Spark 3.4, JDK 11, Scala 2.12 [shuffle]	36m 14s
macos-14/Spark 3.4, JDK 11, Scala 2.12 [expressions]	26m 11s
macos-14/Spark 3.5, JDK 17, Scala 2.13 [expressions]	25m 3s
macos-14/Spark 4.0, JDK 17, Scala 2.13 [fuzz]	18m 54s
macos-14/Spark 3.4, JDK 11, Scala 2.12 [sql]	10m 56s
macos-14/Spark 3.4, JDK 11, Scala 2.12 [fuzz]	35m 44s
macos-14/Spark 3.5, JDK 17, Scala 2.13 [csv]	10m 18s
macos-14/Spark 3.5, JDK 17, Scala 2.13 [shuffle]	18m 9s
macos-14/Spark 3.4, JDK 11, Scala 2.12 [parquet]	17m 57s
macos-14/Spark 4.0, JDK 17, Scala 2.13 [shuffle]	25m 21s
macos-14/Spark 3.4, JDK 11, Scala 2.12 [exec]	17m 29s
macos-14/Spark 3.4, JDK 11, Scala 2.12 [csv]	10m 26s
	6h 49m 45s

Provide feedback