Showing posts with label oracle date change.. Show all posts
Showing posts with label oracle date change.. Show all posts

Tuesday, March 11, 2014

Using to_date function oracle

The to_date function can be used to compare dates :
Usage can be as follows

select
from message 
where message_text like '%888309%' 
and message_received >= to_date('20131119', 'yyyymmdd');

The date format can be changed according to needs.