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.

1 comment:

  1. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
    alternatives to kissanime

    ReplyDelete