Sunday, March 9, 2014

Oracle Java Date Between Sql



String query = "Select type_details as \"TYPE\" ,trans_no as \"#\", reference as Reference ,loc_code AS Location,tran_date as \"Date\", qty as Quantity, CASE WHEN qty >0 THEN 'In' WHEN qty <0 THEN 'Out' END as \"Inventory In - Out \" from inv_dcl_stock_moves where stock_id=? and trunc(tran_date) BETWEEN TO_DATE('"  + Date_From + "', 'yyyy-mm-dd') AND TO_DATE('"  + Date_To+ "', 'yyyy-mm-dd')";
             

No comments:

Post a Comment