请问里面的c_expire_time>=now() 怎么改成ORCALE的语句啊？

Question

在ORCALE中取当前时间应该怎么写啊？在MYSQL里是now()在ORCALE里是用什么呢？select c_id COMPANYwhere c_expire_time>=now()

Answer 1

select sysdate from dual;
直接运行就行
select c_id COMPANY where to_char(c_expire_time,'yyyymmddhh24miss')>=to_char(sysdate,'yyyymmddhh24miss')