Hi

I have tried the above solutions and the syntax provided. It drew a blank result.

Try this also :

Select b.deliverydate

From ordertable as b

Where to_char (b.deliverydate,’DD-Mon-YYYY’) = ‘16-Nov-2017’

- no results also

- data dictionary is like a dictionary created by own with variables’ definitions.