时间戳转换函数:UNIX_TO_ORACLE(long timestamp)
格式转换:TO_CHAR(UNIX_TO_ORACLE(long timestamp), 'yyyy-mm-dd')由于时间戳在库里大部分是VARCHAR,因此排序的时候需将其转成数字,再进行排序(ORDER BY TO_NUMBER(long timestamp) DESC)
TO_CHAR(TO_DATE(String date, 'yyyy-mm-dd hh24:mi:ss'), 'yyyy-mm-dd') AS "日期"