If you are unable to create a new account, please email support@bspsoftware.com

 

Unable to filter datetime parameter with Date fields in Oracle Database ?

Started by srinu1253, 04 Jun 2023 02:59:37 PM

Previous topic - Next topic

srinu1253

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?

MFGF

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.
Meep!