I am working in Business Objects and creating reports through prompting for dates. I want to be able to prompt for reports using the format mm/dd/yyyy. I am pulling from Oracle tables and the date format is shown like this DD-Mon-RRRR.
I have brought the SQL from Business Objects and put it into SQL Navigator to test. The field I am pulling from is a date/timestamp field. 2003-12-01 08:47:04. I am using the SQL statement below to parse out just the date field. It works for that but its not chaning the date value format to mm/dd/yyyy.
to_date(substr(RPT210ERROR_HAND.ERROR_TIMESTAMP,1,10),'yyyy/mm/dd')
This is the value that it returns 1-Dec-2003. I really want to return the value 12/01/2003. Any help would be greatly appreciated
Thanks.
I have brought the SQL from Business Objects and put it into SQL Navigator to test. The field I am pulling from is a date/timestamp field. 2003-12-01 08:47:04. I am using the SQL statement below to parse out just the date field. It works for that but its not chaning the date value format to mm/dd/yyyy.
to_date(substr(RPT210ERROR_HAND.ERROR_TIMESTAMP,1,10),'yyyy/mm/dd')
This is the value that it returns 1-Dec-2003. I really want to return the value 12/01/2003. Any help would be greatly appreciated
Thanks.