Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date Prompt without Timestamp

683231Feb 23 2009 — edited Feb 23 2009
Hello Guys,

I need to create a Date Prompt where I don't need timestamp (Just Distinct Dates).

I used following options but no success.

1) Converted the Physical Column into Date and displays only date without timestamp as desired but when I use distinct in Prompt, It uses timestamp and displays same date with difference timestamp which is not desired.

2) Coverted the Date into Char but while using Ascending order, it does not give me the exact order as the date is character now.

Please help me out with this.

Thanks
Saurabh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2009
Added on Feb 23 2009
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
7 comments
606 views