[Oracle]betweenで日付型条件を指定する

2014年9月1日2021年9月7日

構文
日付項目between 日付1 and 日付2

使用例

SELECT

FROM

USER_TBL

WHERE

BIRTHDATE BETWEEN '20011001 00:00:00' AND '20211001 23:59:59'

ORDER BY

USERNO;

SELECT * FROM USER_TBL WHERE BIRTHDATE BETWEEN '20011001 00:00:00' AND '20211001 23:59:59' ORDER BY USERNO;

SELECT
  * 
FROM
  USER_TBL 
WHERE
  BIRTHDATE BETWEEN '20011001 00:00:00' AND '20211001 23:59:59' 
ORDER BY
  USERNO;

Posted by arkgame