can't use date w/time for in a selection range filter
My records are
- 2021-06-17 16:20:18
- 2021-06-17 16:02:27
- 2021-06-17 17:16:49
only want to select the record 1 & 2.
but below sql not work, how to do
select * from
where per_employees_x
creation_date >= TO_DATE(:p_ee_creation_date_fm, 'YYYY-MM-DD HH24:MI:SS')
AND creation_date<= TO_DATE(:p_ee_creation_date_to, 'YYYY-MM-DD HH24:MI:SS')