find data entered yesterday

Date arithmetic can be convoluted in Oracle. A customer wanted to know how to find all the records entered into a table since midnight. In order to do this, you can convert the column containing the timestamp to character with