[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