SELECT DISTINCT TRUNC(STARTTIME, 'MM') not returning MM format

thelcd

<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>

micajblock

<p>What database are you using? Also Do you want the parameter to be a date or a string? Lastly what version of BIRT are you using?</p>