I don't believe there is a Format function in Oracle SQL for datetime fields.

If your released_date field is already a datetime type, you should not need to enter a format string.

The TRUNC function just truncates the datetime to midnight.

Try:

select *

from db.view

where TRUNC(released_date) <= :startdate

and TRUNC(released_date) >= :enddate

This is assuming you have declared the start & end date parameters as datetime.

Sometimes TRIM is also used, if TRUNC does not get the desired result.

hth

jc