哇哈哈哈哈哈 就是原创的。
select a||' '||b c from (select user_date,to_char(user_date,'yyyy-MM-dd') a,to_char(user_date,'hh24:mi:ss') b from PPEDT_T_MEMBER_USER t order by a asc,b desc)
select a||' '||b c from (select user_date,to_char(user_date,'yyyy-MM-dd') a,to_char(user_date,'hh24:mi:ss') b from PPEDT_T_MEMBER_USER t order by a asc,b desc)