Hello,
I am using oracle database. I have one table with column END_DATE as varchar datatype. The data in the column is like 02/01/2025 in DD/MM/YYYY date format. I am using between date query, but it says - Not a valid month
Please suggest any valid date format so i can convert those dates in valid format. I have tried to_char(), to_date and trunc()
My query :
select * from table where END_DATE between to_date('01/12/2024', 'DD/MM/YYYY.') and to_date('10/02/2025', 'DD/MM/YYYY.')
OR
How can I write query to get last 3 month data from table according to current date. For Ex: BETWEEN SYSDATE-90 and SYSDATE
Thanks in adv !