I have two tables with two different date formats and I need to compare them. I am trying to convert the field Q_RATE_DATE; how do I change it from
TO_DATE(Q_RATE_DATE, 'DD-MON-YY', 'YYYYMMDD')
To render as text:
To reconvert that text back to date:
Editing based on Alex Poole's excellent comment. If you find that one date is stored as a string while the other is a date, you may need to use a mix of the above two queries.
To convert the text string into date: