SYSDATE query
From: Clive van Hilten <cvanhilten_at_hotmail.com>
Date: 8 Oct 2001 02:31:14 -0700
Message-ID: <e5f19d69.0110080131.4bd36ecb_at_posting.google.com>
Date: 8 Oct 2001 02:31:14 -0700
Message-ID: <e5f19d69.0110080131.4bd36ecb_at_posting.google.com>
(running Oracle 8i release 8.1.6.0.0)
I have a query that extracts certain information from a list of cash
account transactions. I would like to amend the query to select only
those transactions where transaction_date was in the last 31 days. I
have seen some examples on the internet that talk about using
round(sysdate), but still cannot get my query to work.
I would be very grateful for any help with the query, which reads as
follows:
SELECT cash_transaction_id, cash_ledger_id, cash_amount,
to_char(transaction_date, 'DD-MM-YY') as transaction_date
FROM webcentre_t_cash_dealing
Thank you.
WHERE cash_ledger_id = 'NAMS1001'
Clive van Hilten Received on Mon Oct 08 2001 - 11:31:14 CEST