to_date

来源:互联网 发布:skype无法连接到网络 编辑:程序博客网 时间:2024/05/18 11:07
select  k.FINANCIAL_SEQ_NO,k.PACKAGE_NUMBER,k.SEND_DATE,k.DUE_DATE,k.INSERT_TIME,k.ERROR_MESSAGE,k.STATUS,k.RESULT_FLAG,(select u.user_name from T_USER u where u.user_id = k.user_id) as USER_NAME
from T_FASR_KOP_LOG k
where 1=1
and k.insert_time >= to_date('11/01/2007','MM/DD/YYYY')
and k.insert_time <= to_date('11/05/2008','MM/DD/YYYY') 
order by k.insert_time desc
原创粉丝点击