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: