Question I have at this point is how would I write the data portion of the
script...in othjer words how do I get it to check the system time and go
back 2 weeks. Keep in mind that me getting this far is based on 5 yr old
oracle classes so I definately am a bit rusty.
There should be a function like now() or current_timestamp and a way to represent time intervals. (Try select now(); or select current_timestamp;) The condition you would write would be shippingdate < current_timestamp - interval '2 weeks'. This works on Postgres anyway.
_______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying
