sql兑现日期降序，时间升序

sql实现日期降序，时间升序
SELECT
type,
create_date,
substr(create_date,1,10) as d,
substr(create_date,12) as t
FROM
history_received_message  order by  d desc,t asc