What is SQL truncate? What is its use?
What is SQL trunc?
Whilst it has many usages, SQL trunc can be used to truncate(delete) part of your date/timestamp to a specified level of precision. For my case, my localdatetime was too precise to the point of milliseconds, while I needed just the date precision so I did
TRUNC(log.CREATED_AT)