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

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