To Pull records between two dates in db2

Question

I tried below two ways they not working

Select * from Table 
where SERV_DATE BETWEEN '03/01/2013'AND    
              '03/31/2013'          

ALSO This is not working

Select * from Table 
where SERV_DATE BETWEEN DATE('03/01/2013') AND     
              DATE('03/31/2013')

What should be the correct format ?

Answer 1

SELECT * FROM tableName WHERE date(modifiedBy_date) between '2017-07-28' AND '2017-08-01';

Works cool for DB2.