bill_home
asked on
Oracle Date Question or .net ADO date error
there is a customer who is getting this error:
ORA-1847 - day of month must be between 1 and last day of the month.
The nls format is dd-mon-rr. They are putting in dates as dd/mm/yyyy. I have watched them do this. There are also .net date validations on the page
The error is happening in .NET. I can't look at the data before the insert as it is happening in code.
Does anyone have any suggestions as to why this is happening?
ORA-1847 - day of month must be between 1 and last day of the month.
The nls format is dd-mon-rr. They are putting in dates as dd/mm/yyyy. I have watched them do this. There are also .net date validations on the page
The error is happening in .NET. I can't look at the data before the insert as it is happening in code.
Does anyone have any suggestions as to why this is happening?
ASKER
Thanks slightwv. I understand the validators. I was wondering if it was an oracle issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I really don't believe it is an app issue. Since these customers are the only people in North and South America with this problem.
I beleive it is some kind of strange oracle issue...I think
Thanks for your input. I will assign points accordingly.
I beleive it is some kind of strange oracle issue...I think
Thanks for your input. I will assign points accordingly.
It could be a regional OS setting or an NLS_LANG issue but the underlying error is pretty specific: Oracle is receiving a string it is trying to implicitly convert into a date and it does not recognize the format it is receiving.
ASKER
could you expand on this NLS_LANG -where can I take a look at that?
I doubt it is an NLS_LANG issue but here is the info:
http://download.oracle.com/docs/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG189
http://download.oracle.com/docs/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG189
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hhhh
If the problem isn't solved, why close the question?
ASKER
still an issue closing and assigning points
You can change the database to use a new default format which I would not recommend.
All the .Net validators do is validate that it believes it is a valid date format. Not that it is 'valid' for Oracle.