Re: Oracle Reports Date problem

frank.van.bortel_at_gmail.com wrote:
> hummels_at_insightbb.com schreef:
>
> > I have a Query that works just fine in TOAD, but when put into Oracle
> > Reports, it behaves differently.
>
> Must be beacuse your setting are different.
> I would suspect NLS_DATE_FORMAT would be set in your TOAD session,
> but not in your reports environment.
>
> BTW, I think using a trunc would be more efficient, if your date column
> just
> has the date portion, and not the time (that is, time is truncated, and
> stored
> as 12:00)
>
> Your where clause would then be
> where (date_column) = trunc(:p1_date)

I thought the same thing about the formats being different. I'll still look around at that. But, a date type column is a date no matter what the Formating is, isn't it? Also, the act_end column I'm working with does have the time included. So I can't trunc as I want to compare it down to the time. Received on Wed Aug 23 2006 - 15:42:32 CEST