At times things seem just too easy, so I want to confirm that this is the
correct syntax.
I am looking for the interval (aging) for these invoices. I guess I am
concerned because I guessed at the syntax. Is there a better way to do
this?
billdate is type 'date'
SELECT ('now'-billdate) FROM fcinvoiced WHERE client = 'smith';
Ted