
November 1st, 2003, 01:20 PM
|
|
|
I don't think add_months is the correct function here, I think you want to use trunc
ie.
PHP Code:
select * from shipment
where trunc(date_received,'month') = to_date('10-2003','mm-yyyy')
Now I didn't check if i have the exact correct parameters, but this should give you the idea.
|