Not Able to Login to Oracle Database from SQL*Plus

Oracle SQL: How to write a que for filterting Date columns

Oracle SQL date format can be tricky to understand and could make you loose time to figure out why a query is not working. We use TRUNCATE and TO_DATE function to create a query to filter by a date on a timestamp column.