Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
SELECT DISTINCT TRUNC(STARTTIME, 'MM') not returning MM format
Migrateduser
<p>Hi I have a select that is not returning truncated data in my Birt parameters input...</p><p> </p><p>I populate my input parameters via the following select:</p><p> </p><div>SELECT DISTINCT TRUNC(STARTTIME, 'MM')</div><div>from MYTABLE</div><div> </div><div>hoping that it will output Dates as</div><div> Oct 2013</div><div> Nov 2013</div><div>etc...</div><div>However, it outputs Oct 1, 2013 12:00 AM</div><div> </div><div>How can I customize the report parameter to show only Month/Year..</div><div> </div><div>Thanks,</div>
Find more posts tagged with
Comments
There are no comments yet