Hello all.
I am very new to Oracle databases. I am running a simple query on Oracle SQL Developer. I am trying to limit the number of results by a where statement against a timestamp field, status_date. This does not work
where to_char(d.status_DATE, 'MM/DD/YYYY') > '01/01/2020'.
it still returns all records.
I am sure it is a simple solution but one that I have not been able to find a solution to.
Can somebody please educate me on how to use timestamp fields in Oracle?
Thank you in advance,
Aaron Montoya