Eclipse Community Forums: BIRT » Ive been experimenting with oracle time formats, but nothing works

Home » Archived » BIRT » Ive been experimenting with oracle time formats, but nothing works

Ive been experimenting with oracle time formats, but nothing works [message #140498]

Tue, 07 March 2006 06:37

Eclipse User

I am using trial and error to get a datetime into a report. E.g. using
something like the following:
select to_char(sysdate, 'DD/MM/YY HH24:MI:SS') as mydate from dual

When I do this, the dataa set preview shows the right date and time, ( I
guess its not doing anything with date objects), but in my report the
date/time string comes out blank.

Ive tried lots of formats, but as Birt hangs for nearly 10 minutes each time
I open the data set for editing, this is a long and tedious process which
will take days (and cost thousands of pounds).

Has anyone manged to get a date & time (including seconds) out of oracle
into a report?

What format is it expecting from the DB?

Is noone out there using brit for datetimes?

Birt.

Re: Ive been experimenting with oracle time formats, but nothing works [message #140605 is a reply to message #140498]

Tue, 07 March 2006 08:02

Eclipse User

Originally posted by: b.noemailspam.nothere

Try RTRIM() around your TO_CHAR. I found that using TO_CHAR was adding
extra spaces onto the end of my dates.
Having said that, I'm only displaying the a Month.

birt wrote:
> I am using trial and error to get a datetime into a report. E.g. using
> something like the following:
> select to_char(sysdate, 'DD/MM/YY HH24:MI:SS') as mydate from dual
>
> When I do this, the dataa set preview shows the right date and time, ( I
> guess its not doing anything with date objects), but in my report the
> date/time string comes out blank.
>
> Ive tried lots of formats, but as Birt hangs for nearly 10 minutes each time
> I open the data set for editing, this is a long and tedious process which
> will take days (and cost thousands of pounds).
>
> Has anyone manged to get a date & time (including seconds) out of oracle
> into a report?
>
> What format is it expecting from the DB?
>
> Is noone out there using brit for datetimes?
>
> Birt.
>
>

Re: Ive been experimenting with oracle time formats, but nothing works [message #142002 is a reply to message #140498]

Thu, 09 March 2006 07:48

Eclipse User

Originally posted by: r.budner.abg.com.pl

Hello,

I've recently suggested you should report a bug to BIRT (in your
prevoius post). Since that I have found interesting explanation of our
problem. Read this
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/ jdbc_faq.htm#08_01

Oracle JDBC Drivers are responsible for mapping SQL DATE to
java.sql.Date which doesn't contain the time part.
Oracle also gives us solution on how to change this behaviour.

Robbo

Previous Topic:	BIRT Examples plugin
Next Topic:	can I populate report data set by writing a Java class

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 21:17:35 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter