ORA-00932: inconsistent datatypes: expected NUMBER got INTERVAL DAY TO SECOND

执行以下SQL语句报错：

select
      trunc(sysdate - create_time) as register_days,
      create_time as register_date
from t_user
where user_id = '1001'

ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got INTERVAL DAY TO SECOND

因为我的create_time类型是TIMESTAMP，可以转换类型为date：

select
      trunc(sysdate - cast(create_time as date)) as register_days,
      create_time as register_date
from t_user
where user_id = '1001'