Oracle 11g timestamp format mask
Posted on 2012-08-22
I have a report parameter that has to be of datetime format. I'm I have a situation where customers imput the date as date format (reports are launched through a LMS).. I want to truncate the time portion essentially going from datetime to date to filter the report dataset.
How does Oracle 11g handle default format if you input date into a dateime(timestamp) variable? ex. 6/19/2012 ----> 6/19/2012 12:00:00 ?
I'm trying to format the timestamp as trunc(''6/19/2012 12:00:00', 'mm/dd/yyyy hh:mi.ss') but I'm getting format errors, like ora-018... invalid month, etc.