I think you should not rely on the implicit conversion. It is a bad practice.
Instead you should try like this:
datenum >= to_date('11/26/2013','mm/dd/yyyy')
or like
datenum >= date '2013-09-01'
More Related Contents:
- How are dates stored in Oracle?
- Using date in a check constraint, Oracle
- How to get records randomly from the oracle database?
- Formatting DATE in oracle
- How to use a table type in a SELECT FROM statement?
- Oracle date difference to get number of years
- Convert epoch to date in sqlplus / Oracle
- Oracle: how to add minutes to a timestamp?
- Valid Date Checks in Oracle
- How to get the week day name from a date?
- How to convert “1985-02-07T00:00:00.000Z” (ISO8601) to a date value in Oracle?
- Calculate difference between 2 date / times in Oracle SQL
- The order of a SQL Select statement without Order By clause
- MySQL Query – Records between Today and Last 30 Days
- Auto Increment for Oracle
- Add a auto increment primary key to existing table in oracle [duplicate]
- ways to avoid global temp tables in oracle
- How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
- String to date in Oracle with milliseconds
- Create Pivot view in SQL from a SQL table
- Why doesn’t PL/SQL respect privileges granted by Roles?
- ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
- Speed up to_sql() when writing Pandas DataFrame to Oracle database using SqlAlchemy and cx_Oracle
- Is there any way to have the JBoss connection pool reconnect to Oracle when connections go bad?
- Get ID of last inserted record in oracle db
- oracle SQL plus how to end command in SQL file?
- Why is the GETDATE() an invalid identifier
- ORA-04091: table [blah] is mutating, trigger/function may not see it
- How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
- Grant Select on all Tables Owned By Specific User