2015 first Blog, Oracle time period query, to_date and To_char use comparison

Write in front:
Time period query, when using To_date, including the start date, does not include the end date;
You can include a start date or an end date when using To_char. Specific effects

1. To_date use, no query to end date.

2. To_char use, query to end date.

3.sql Contrast

--includes start date, excluding end date Select*fromsyst_logwhere (Operate_time > To_date (' 2015-02-03 ', ' yyyy-mm-dd ') and Operate_time < To_date (' 2015-02-06 ', ' yyyy-mm-dd ')) ORDER byoperate_time desc;--includes the start date, also including the end date Select*fromsyst_logwhereto_char ( Operate_time, ' yyyy-mm-dd ') >= ' 2015-02-03 ' and To_char (operate_time, ' yyyy-mm-dd ') <= ' 2015-02-06 ' ORDER Byoperate_time DESC;

2015 first Blog, Oracle time period query, to_date and To_char use comparison