Re: Oracle Reports Date problem
From: <frank.van.bortel_at_gmail.com>
Date: 23 Aug 2006 01:35:00 -0700
Message-ID: <1156322100.856501.107100_at_m73g2000cwd.googlegroups.com>
Date: 23 Aug 2006 01:35:00 -0700
Message-ID: <1156322100.856501.107100_at_m73g2000cwd.googlegroups.com>
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)
Received on Wed Aug 23 2006 - 10:35:00 CEST