cancel
Showing results for 
Search instead for 
Did you mean: 

ora-01861 literal does not match format string

Former Member
0 Kudos

Post Author: Valerie

CA Forum: Data Connectivity and SQL

I have an insert statement which includes dates. When I remove them from the insert statement I am able to view the data through crystal reports. When I include them I receive this error. Any advice?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Post Author: Jagan

CA Forum: Data Connectivity and SQL

Have you done an internet search on ora-01861? As the message suggests, your date string literal does not match the format string specified. e.g. you supplied a date string literal '01/03/07' and a date format string 'dd-Mon-yyyy'.

Former Member
0 Kudos

Post Author: synapsevampire

CA Forum: Data Connectivity and SQL

Ummm, remove them ?

Try posting technical informatin when seeking technical answers.

Version of Crystal?

Version and connectivity used for Oracle?

How are you executing the SQL, in a Stored Procedure, View, Command Object, or?

Does the SQL work from another tool?

You might need to post the SQL as well.

-k