Sql query with a where clause comparing an Oracle date to a Webcon date.

0

Hi,

I have a following problem. I've created a data table form field that downloads data from SQL query. In that SQL query I have a following where clause, which compares a date from Oracle table to a date from a form field that is completed by an user (it is "user's date"):

"where table1.date = User's date: date acc. browser settings(text)"

and it doesn't work because of different date formats. I've tried multiple methods and nothing worked. Do you know any solution?

However, the following where clause works very well, what tells me that the problem is date format.
"where table1.date = to_date('2022/04/29','yyyy/mm/dd')"