Hi All,
Hope you all are fine.
On my UI user is giving date format for from date as YYYYMM and to date as YYYYMM.
In my db view the column is of varchar type and data is stored as Dec-23 this is for whole month one row, other rows have Nov-23, Oct-22 so on
when i execute the query select * from ch_pay where gl_month in ('Dec-23', ‘Nov-22’, ‘Oct-22’) .. it is working fine .. but when i use to_date conversion i am getting different errors as date should be in this range or non numerical character found.
Can someone show me how to do a date conversion from UI which accepts from and to date as bind parameters to query like for example 202312(YYYYMM) and pass it to column as ‘Dec-23’
Thanks,
Vinay