SQL Language (MOSC)

MOSC Banner

Timestamp compare in where clause failing

edited Sep 18, 2019 12:09PM in SQL Language (MOSC) 6 commentsAnswered ✓

Need to get snap_id from dba_snapshot_hist table for particular time. Select statement is failing with error.

select snap_id,BEGIN_INTERVAL_TIME,END_INTERVAL_TIME from dba_hist_snapshot

where TO_DATE(TO_CHAR(BEGIN_INTERVAL_TIME,'YYYY-MON-DD HH24:MI'),'YYYY-MON-DD HH24:MI')=TO_DATE(TO_CHAR('&begin_time','YYYY-MON-DD HH24:MI'), 'YYYY-MON-DD HH24:MI')

statement failing with Invalid Number while entering date value 17-SEP-2019 0800

Any one please suggest how can I get snap_id of particular time using runtime input (&)

Thanks

Tagged:

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