How to Query via a Date Literal in Oracle You can refer to a literal date like this: WO.REPORTDATE >= date'2017-07-23' Can also convert a string to a date time like this: