>>> spark.conf.set("spark.sql.session.timeZone", "Asia/Shanghai")
>>> spark.sql("SELECT CAST(TIMESTAMP '1970-01-01 00:00:00' AS LONG)").show()  # doctest: +SKIP
+-----------------------------------------------+
|CAST(TIMESTAMP '1970-01-01 00:00:00' AS BIGINT)|
+-----------------------------------------------+
|                                         -28800|
+-----------------------------------------------+

>>> spark.sql("SELECT CAST(TIMESTAMP('1970-01-01 00:00:00') AS LONG)").show()  # doctest: +SKIP
+-----------------------------------+
|CAST(1970-01-01 00:00:00 AS BIGINT)|
+-----------------------------------+
|                             -28800|
+-----------------------------------+

>>> spark.sql("SELECT CAST(TIMESTAMP '1970-01-01 00:00:00+00:00' AS LONG)").show()
+-----------------------------------------------+
|CAST(TIMESTAMP '1970-01-01 08:00:00' AS BIGINT)|
+-----------------------------------------------+
|                                              0|
+-----------------------------------------------+

>>> spark.sql("SELECT CAST(TIMESTAMP('1970-01-01 00:00:00+00:00') AS LONG)").show()
+-----------------------------------------+
|CAST(1970-01-01 00:00:00+00:00 AS BIGINT)|
+-----------------------------------------+
|                                        0|
+-----------------------------------------+

>>> spark.conf.set("spark.sql.session.timeZone", "America/Los_Angeles")
>>> spark.sql("SELECT CAST(TIMESTAMP '1970-01-01 00:00:00' AS LONG)").show()  # doctest: +SKIP
+-----------------------------------------------+
|CAST(TIMESTAMP '1970-01-01 00:00:00' AS BIGINT)|
+-----------------------------------------------+
|                                          28800|
+-----------------------------------------------+

>>> spark.sql("SELECT CAST(TIMESTAMP '1970-01-01 00:00:00+00:00' AS LONG)").show()
+-----------------------------------------------+
|CAST(TIMESTAMP '1969-12-31 16:00:00' AS BIGINT)|
+-----------------------------------------------+
|                                              0|
+-----------------------------------------------+

>>> spark.sql("SELECT CAST(TIMESTAMP '1970-01-01 00:00:00+08:00' AS LONG)").show()  # doctest: +SKIP
+-----------------------------------------------+
|CAST(TIMESTAMP '1969-12-31 08:00:00' AS BIGINT)|
+-----------------------------------------------+
|                                         -28800|
+-----------------------------------------------+

>>> spark.sql("SELECT CAST(TIMESTAMP '2024-11-03 01:30:00' AS LONG)").show()  # doctest: +SKIP
+-----------------------------------------------+
|CAST(TIMESTAMP '2024-11-03 01:30:00' AS BIGINT)|
+-----------------------------------------------+
|                                     1730622600|
+-----------------------------------------------+

>>> spark.sql("SELECT CAST(TIMESTAMP '2024-11-03 02:30:00' AS LONG)").show()  # doctest: +SKIP
+-----------------------------------------------+
|CAST(TIMESTAMP '2024-11-03 02:30:00' AS BIGINT)|
+-----------------------------------------------+
|                                     1730629800|
+-----------------------------------------------+

>>> spark.sql("SELECT CAST(TIMESTAMP '2025-03-09 01:30:00' AS LONG)").show()  # doctest: +SKIP
+-----------------------------------------------+
|CAST(TIMESTAMP '2025-03-09 01:30:00' AS BIGINT)|
+-----------------------------------------------+
|                                     1741512600|
+-----------------------------------------------+

>>> spark.sql("SELECT CAST(TIMESTAMP '2025-03-09 02:30:00' AS LONG)").show()  # doctest: +SKIP
+-----------------------------------------------+
|CAST(TIMESTAMP '2025-03-09 03:30:00' AS BIGINT)|
+-----------------------------------------------+
|                                     1741516200|
+-----------------------------------------------+

>>> spark.sql("SELECT CAST(TIMESTAMP '2025-03-09 03:30:00' AS LONG)").show()  # doctest: +SKIP
+-----------------------------------------------+
|CAST(TIMESTAMP '2025-03-09 03:30:00' AS BIGINT)|
+-----------------------------------------------+
|                                     1741516200|
+-----------------------------------------------+
