[jira] [Created] (SPARK-41455) Resolve dtypes inconsistencies of date/timestamp functions

["Xinrong Meng (Jira)" <ji...@apache.org>]

Xinrong Meng created SPARK-41455:
------------------------------------

             Summary: Resolve dtypes inconsistencies of date/timestamp functions
                 Key: SPARK-41455
                 URL: https://issues.apache.org/jira/browse/SPARK-41455
             Project: Spark
          Issue Type: Sub-task
          Components: PySpark
    Affects Versions: 3.4.0
            Reporter: Xinrong Meng


When implementing date/timestamp functions, we notice inconsistent dtypes with PySpark, as shown below.

{code:python}

>> sdf.select(SF.current_timestamp()).toPandas().dtypes
current_timestamp()    datetime64[ns]
dtype: object
>>> cdf.select(CF.current_timestamp()).toPandas().dtypes
current_timestamp()    datetime64[ns, America/Los_Angeles]
{code}


We may have to implement `is_timestamp_ntz_preferred` for Connect.

After the fix, tests of those date/timestamp functions which use `compare_by_show` should be switched to `toPandas` comparison.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org