PL/SQL (MOSC)

MOSC Banner

ORA-01861: literal does not match format string

edited May 9, 2019 4:53AM in PL/SQL (MOSC) 4 commentsAnswered ✓

I have a view created on Oracle DB 11g with the structure like this:

The column event_dtm is defined as: TO_DATE (b.general_2, 'dd-mm-yyyy hh24:mi:ss') event_dtm (the general_2 allows null)

The column created_dtm is defined as: a.charge_date created_dtm (charge_date is not null column)

I have 2 queries:

The 1st query:

SELECT COUNT(*)

FROM SELFCARE.HCPT_INTEC_USAGE_DETAILS_UAT

WHERE CREATED_DTM BETWEEN TO_DATE('01-10-2018','DD-MM-YYYY') AND TO_DATE('02-10-2018','DD-MM-YYYY');

Result:

The 2nd query:

SELECT COUNT(*)

FROM SELFCARE.HCPT_INTEC_USAGE_DETAILS_UAT

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