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′;
select * from POST_SITE where TO_CHAR(POST_TMS,’DD-MM-YYYY’) =’25-02-2014′;
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…
656 total views, 1 views today