oracle+java to get date from database
i want to get details from data base in which date is of format '08-MAR-14 03.52.17.000000000 PM' .i know its possible to get date SELECT ... FROM ... WHERE somecol >= '2011-01-01' AND somecol <= '2011-01-30' in this data i am having time also how is it possible to get only date .to connect in am using java to connect to oracle.