SYSDATE query

(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
WHERE cash_ledger_id = 'NAMS1001'

Thank you.

Clive van Hilten Received on Mon Oct 08 2001 - 11:31:14 CEST