[10.0] fix: return pd.Timestamp or pd.Series[datetime64] for date.to_pandas()

[10.0] fix: return pd.Timestamp or pd.Series[datetime64] for date.to_pandas() #3344