how to convert month number to month name in oracle? : I have a .java page and in that page I am getting the 'from' & 'to' date value from a jsp page. string from = "18-Jan-2018"; string to = "20-Jan-2018"
In that java page i have written String f_date_p ="SELECT TO_DATE('"+from+"') +90 from dual" ; and  String t_date_m = "SELECT TO_DATE('"+to+"') -90 from dual" ; After executing this, I am getting fdayp = "2018-04-18 00:00:00.0" .[initially String fdayp ="";]  and  String t_date_m = "SELECT TO_DATE('"+to+"') -90 from dual" ;[initially String tdaym ="";] tdaym = "2017-10-22 00:00:00.0"
But i got failed to execute this oracle query-  " select count(*)from a where start_date BETWEEN '2018-04-18 00:00:00.0' and '2017-10-20 00:00:00.0' 
and id='703301' ";