Oracle comparing timestamp with date

Question

I have a timestamp field and I just want to compare the date part of it in my query in Oracle  How do I do that   SELECT   FROM Table1 WHERE date field1     2012-01-01

User · Accepted Answer

You can truncate the date part   select   from table1 where trunc field1    to date  2012-01-01    YYYY-MM-DD     The trouble with this approach is that any index on field1 wouldn t be used due to the function call   Alternatively  and more index friendly   select   from table1   where field1  gt   to timestamp  2012-01-01    YYYY-MM-DD       and field1  lt  to timestamp  2012-01-02    YYYY-MM-DD

User · Answer

to date format worked for me  Please consider the date formats  MON-  MM     -   t start date  gt   to date  14 11 2016 04 01 39    DD MM YYYY HH24 MI SS   t start date  lt  to date  14 11 2016 04 10 07    DD MM YYYY HH24 MI SS

User · Answer

You can truncate the date  SELECT   FROM Table1 WHERE trunc field1    to Date  2012-01-01   YYY-MM-DD     Look at the SQL Fiddle for more examples

[oracle] Oracle comparing timestamp with date

Examples related to oracle