Oracle current_date or sysdate without hours, minutes, seconds
java, oracle, sql
Solution
Maybe you should try
trunc(sysdate)
function.
Problem
Is there any way to get rid of the time of day when using `current_date` or `sysdate`. I'm trying to only the store the date as `YYYY-MM-DD` , but current_date is giving me `YYYY-MM-DD HH:MM:SS:MS` Or when comparing the dates, it only compares the date and not the time would be just as good. Any help would be awesome, thanks.