This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 38%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
hi here is my request
select * from users a WHERE trunc(A.registered) between to_date(?,'dd/mm/yyyy') and to_date(?,'dd/mm/yyyy') ORDER BY a.name
i use an oracle db (odbc driver) with SSRS when i execute my request i get the error ERROR[HY000][Oracle][ODBC][Ora]ORA-01858: a non-numeric character was found where a numeric was expected can you help me?
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
I solved the problem by changing the parameter values in the dataset properties like this: for each parameter, dataset settings > parameters > parameter value > I added =Format(CDate(Parameters!param1.Value), "yyyy-MM-dd") to make the format match the date type in the oracle table
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @user
Thank you for your feedback. I'm glad your problem was solved. If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.
Best regards,
Aniya
Hi @user I found this link for you about this error: https://stackoverflow.com/questions/29852389/getting-error-ora-01858-a-non-numeric-character-was-found-where-a-numeric-was. According to your comment, do you want to change the format of the SSRS date parameter? The format of SSRS date parameters is generally a date format in the language specified in the browser. If you want to change it, you can refer to this link: https://stackoverflow.com/questions/29775170/i-want-datetime-parameter-in-ddmmyyyy-format-in-ssrs-report. Best regards, Aniya
The error is raised by Oracle, not by SSRS, so you may better ask in an Oracle forum. What for parameter values do you pass?
Thanks Mister OLAF the values of my parameters are dates. in SSRS report, format date is DD/MM/YYYY in the parameter text box; but in my oracle table is YYYY-MM-DD how to solve this since I want to use parameters?
the values of my parameters are dates in the parameter text box of ssrs report, the date format is dd/mm/yyyy but in the oracle table the date format is yyyy-mm-dd how to solve this? can we change the date format in ssrs?
but in my oracle table is YYYY-MM-DD
So you store your dates not in a column of type "date", but varchar?
Dates are stored in a column of type "datetime" format is YYYY-MM-DD HH24:MI:SS in the oracle table