[Oracle]betweenで日付型条件を指定する
構文
日付項目between 日付1 and 日付2
使用例
SELECT * FROM USER_TBL WHERE BIRTHDATE BETWEEN '20011001 00:00:00' AND '20211001 23:59:59' ORDER BY USERNO;
Coding Changes the World
構文
日付項目between 日付1 and 日付2
使用例
SELECT * FROM USER_TBL WHERE BIRTHDATE BETWEEN '20011001 00:00:00' AND '20211001 23:59:59' ORDER BY USERNO;