[FEA] Support non-UTC timezone for casting from date to timestamp

[res-life]

Is your feature request related to a problem? Please describe.
From a customer, need support non-UTC timezone for casting from date to timestamp
Tests:

TZ=Asia/Shanghai ./integration_tests/run_pyspark_from_build.sh -s -k test_date_to_timestamp

case:

@pytest.mark.parametrize('parser_policy', ["LEGACY", "CORRECTED", "EXCEPTION"], ids=idfn)
def test_date_to_timestamp(parser_policy):
    parser_policy_dic = {"spark.sql.legacy.timeParserPolicy": "{}".format(parser_policy)}
    incompatible_dic = {"spark.rapids.sql.incompatibleDateFormats.enabled": True}
    assert_gpu_and_cpu_are_equal_sql(
        lambda spark : unary_op_df(spark, date_gen),
        "tab",
        "SELECT cast(a as timestamp) from tab",
        conf=copy_and_update(parser_policy_dic, incompatible_dic))