I’m trying to join two Oracle tables (basically to pull in a daily rate against the date in another table), but the table I’m pulling the date from has the timestamp in it. I’m seeing a lot of solutions for the “Literal does not match format string” problems, but they all seem to be for entering a date directly instead of joining from another table. Apologies if I didn’t understand the earlier solutions correctly, but I’m very novice to SQL. My code currently is basically:

select gdr.conversion_rate from apps.gl_daily_rates gdr, apps.project_agreements pa where gdr.rate_date = pa.agreement_date

With the pa.agreement_date value being the one with the extra times stamp in it. I tried using the todate function around the pa.agreement_date in the join but was definitely not doing it correctly, if that’s the proper solution.
Thanks!