date and time parameter in BIRT report

liz

I am using BIRT(2.5.1) to create a report via a stored procedure. my database is oracle. the stored procdure has date and time parameter. how can I format the datetime parameter when it is passed in, it looks like '2011/04/11 13:23:23'(yyyy/mm/dd hh:mm:ss)? Any help will be appreciated.

mwilliams

So, your user selects a date or something along those lines and you need to format it from yyyy-MM-dd HH:mm:ss:SSS as BIRT formats it to the format you have listed above? If this is the case, you should be able to do something like:

dtFormat = new Packages.java.text.SimpleDateFormat("yyyy/MM/dd hh:mm:ss");
myDate = dtFormat.format(params["dateParameter"]);

Let me know if I'm misunderstanding.