Unable to filter datetime parameter with Date fields in Oracle Database. Tried Converting/typecasting the dates. Tried with To_Char to change the dates to desired format MM-DD-YYYY HH24:MI:SS. It does'nt work ? What is the correct approach to handle this situation?
Quote from: srinu1253 on 04 Jun 2023 02:59:37 PM
Unable to filter datetime parameter with Date fields in Oracle Database. Tried Converting/typecasting the dates. Tried with To_Char to change the dates to desired format MM-DD-YYYY HH24:MI:SS. It does'nt work ? What is the correct approach to handle this situation?
Hi,
Can you be more specific about what you mean by "Unable to filter" and "it doesn't work"? Are you getting an error? The wrong result? No result? What exact expression or expressions are you using?
Normally a filter based on the date column in this format would work:
[Your Oracle Date Field] in_range ?Your Parameter?
Cheers!
MF.