SQL*Plus (MOSC)

MOSC Banner

can't use date w/time for in a selection range filter

in SQL*Plus (MOSC) 4 commentsAnswered ✓

My records are

  1. 2021-06-17 16:20:18
  2. 2021-06-17 16:02:27
  3. 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')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center