[thelist] Oracle Date Swizzle?
Luther, Ron
ron.luther at hp.com
Tue Aug 26 14:35:15 CDT 2003
Plunkett, Matt noted further:
>>Hrm. That suggests it is converting it somewhat though.
Hi Matt,
While walking up the steps to another meeting I suddenly remembered
that I may be running against a 'view' instead of a physical table.
I'm wondering now if that extra level of interaction is what is causing
the problems. I'll drill into that and see if that's where my holdup
is.
>>What are you doing with this date once you get it converted?
Oh, I need to 'bucketize' some open sales orders ... so I'm looking
to add some "select {if due more than 15 but less than 30 days from
*today* give me the net open order qty - else zero} etc" fields to
my report. (It's a format the users are comfortable with.)
[I've inherited a report with a similar structure. Unfortunately, that
report does all of the date arithmetic in memory on the end-user's
machine ... I'd like to push the math back to the SQL and realize some
(in this case anyway) _significant_ performance improvements!]
Thanks,
RonL.
More information about the thelist
mailing list