on 07-11-2007 10:41 PM
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?
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'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.