select with timestamp or date in oracle

select with timestamp or date in oracle:

If you want to select the date field or timestamp field with the given date, then you have to use the query like this,

select * from TABLE_NAME where TO_CHAR(TIMESTAMP_OR_DATE_COLUMN,’DD-MM-YYYY’) =’25-02-2014′;

Eg:

select * from POST_SITE where TO_CHAR(POST_TMS,’DD-MM-YYYY’) =’25-02-2014′;

here
POST_SITE is the name of the table and
POST_TMS is the name of the column which is either date field or timestamp field.

Please add your comments in the below comment area…