I am using Oracle 11g and while trying to run Select
query with a condition on column of type Timestamp, the following error occurs.
ORA-01843: not a valid month
01843. 00000 - "not a valid month"
*Cause:
*Action:
My query is similar to this -
SELECT * FROM TABLE T WHERE T.LAST_ACCESS_DATE < '2016/01/30';
Is there any function to properly fomat the Date or is there any particular pattern in which Date should be passed?