HI
I want data between two dates.
select order_NO FROM SALES_ORDER WHERE TO_DATE(ORDER_DATE,'MM-DD-YYYY') BETWEEN TO_DATE('03-01-2008','MM-DD-YYYY') AND TO_DATE('03-11-2008','MM-DD-YYYY')
but it doesn't work my field in table is sysdate type.
select sysdate from dual
3/12/2008 12:18:35 AM
thanks