| ORA-01841 [message #285993] |
Thu, 06 December 2007 04:37  |
kuwait
Messages: 55
Registered: October 2007
|
Member |
|
|
Hi all
I have a data block with the following where clause
(TNCDATE >= TO_DATE( '01/04/:CB.YER' ))
AND
(TNCDATE <= TO_DATE( '31/03/(:CB.YER+1)' ))
When i run it gave the msg unable to perform query and this was the error:
"ORA-01841: (full) year must be between -4713 and +9999, and not be 0"
- CB.YER is a char that ranges from 03 to 07(current year)
Please can you help me?
Thanks
[Updated on: Thu, 06 December 2007 04:38] Report message to a moderator |
|
|
|
| Re: ORA-01841 [message #285998 is a reply to message #285993] |
Thu, 06 December 2007 04:54  |
kuwait
Messages: 55
Registered: October 2007
|
Member |
|
|
Thanks all I've solved the problem
This is my solution:
(TNCDATE>=TO_DATE('01/04/'||:CB.YER,'dd/mm/yy'))
and
(TNCDATE<=TO_DATE('31/03/'||(:CB.YER+1),'dd/mm/yy'))
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
