I have created a date object in IDT , and the Column in the database is also Date Type , but when I make this object and go to show values it shows the values in the screen shot for example 2013-03-15 00:00:00.000 , but actual the values in the database is 03/15/2103 , I have tried trunc and formatdate functions to get rid of the time stamp , but im not able to do that , it keep of showing the same timestamp values, and if I change the data type to Date then after I do Integrity check on this object it throws error as attached .
The reason why I want to make it date type , because I want to show Calendar In the prompt in my report , if I leave it as a timestamp, ,then the Calendar is not coming in the report , the prompt created with Timestamp is also attached in the screenshot ,
so Basically two things
1) - The date object with timestamp is not showing calendar in the prompt in my report.
2)- If I convert the data type of the Date object to Date from Date Time , it gives the calendar in the prompt , but in the Integrity it shows the error attached .