2004-10-01 09:12:12
datatime?you mean it's String?you can split to the format of "2004-10-01"
and then you can covert it to date using SQLselect to_date('2004-10-01','yyyy-mm-dd') from dual
datatime?you mean it's String?you can split to the format of "2004-10-01"
and then you can covert it to date using SQLselect to_date('2004-10-01','yyyy-mm-dd') from dual
用to_char(日期字段,'yyyy-mm-dd')