有关Sql中时间范围的问题

1、将日期转换为字符串再比较

<span style="color: #0000ff;">select</span> sysdate nowtime <span style="color: #0000ff;">from</span> dual <span style="color: #0000ff;">where</span> to_char(sysdate,<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">yyyymmdd hh24:mi:ss</span><span style="color: #ff0000;">‘</span>) <span style="color: #808080;">between</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">20200401</span><span style="color: #ff0000;">‘</span> <span style="color: #808080;">and</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">20200403</span><span style="color: #ff0000;">‘</span>;<br>//02-APR-20,时间范围是2020-04-01 00:00:00 至 2020-04-03 00:00:00 

<span style="color: #0000ff;">select</span> sysdate time <span style="color: #0000ff;">from</span> dual <span style="color: #0000ff;">where</span> to_char(sysdate,<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">yyyymmdd</span><span style="color: #ff0000;">‘</span>) <span style="color: #808080;">between</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">20200402</span><span style="color: #ff0000;">‘</span> <span style="color: #808080;">and</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">20200402</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">;
</span><span style="color: #808080;">//</span><span style="color: #800000; font-weight: bold;">02</span><span style="color: #808080;">-</span>APR<span style="color: #808080;">-</span><span style="color: #800000; font-weight: bold;">20</span>,时间范围是2020-04-02 00:00:00 至 2020-04-02 24:00:00 

2、将字符串转化为日期再比较

<span style="color: #0000ff;">select</span> sysdate nowtime <span style="color: #0000ff;">from</span> dual <span style="color: #0000ff;">where</span> sysdate <span style="color: #808080;">between</span> to_date(<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">20200401</span><span style="color: #ff0000;">‘</span>,<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">yyyyMMdd</span><span style="color: #ff0000;">‘</span>) <span style="color: #808080;">and</span> to_date(<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">20200403</span><span style="color: #ff0000;">‘</span>,<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">yyyyMMdd</span><span style="color: #ff0000;">‘</span>);<br>//02-APR-20,时间范围是2020-04-01 00:00:00 至 2020-04-03 00:00:00 

注意：如果不在字符串中指定时间则转换的时间默认为0点，所以前后日期一致则时间间隔为0。

<span style="color: #0000ff;">select</span> to_char(to_date(<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">20200402</span><span style="color: #ff0000;">‘</span>,<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">yyyyMMdd</span><span style="color: #ff0000;">‘</span>),<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">yyyyMMdd hh24:mi:ss</span><span style="color: #ff0000;">‘</span>) nowtime <span style="color: #0000ff;">from</span><span style="color: #000000;"> dual;
</span><span style="color: #808080;">//</span><span style="color: #800000; font-weight: bold;">20200402</span> <span style="color: #800000; font-weight: bold;">00</span>:<span style="color: #800000; font-weight: bold;">00</span>:<span style="color: #800000; font-weight: bold;">00</span>

有关Sql中时间范围的问题

标签：指定   color   时间间隔   div   where   style   dual   sele   apr