ORACLE DATE TYPE

来源:互联网 发布:起名字的软件 编辑:程序博客网 时间:2024/06/05 19:43
 

select *

from TABLE_AWHERE TO_CHAR(BUSINESS_DATE,'DD-MON-yyyy') = (selectDISTINCT (to_CHAR(BUSINESS_DATE,'DD-MON-yyyy'))

from TABLE_BWHEREROWNUM <2);

 

TO_CHAR(BUSINESS_DATE,'DD-MON-yyyy')

THE RESULT LIKE THIS

07-APR-2011

原创粉丝点击