TRUNC関数の引数に'MONTH'を指定する
SELECT
TRUNC(TO_DATE('2016/11/03', 'YYYY/MM/DD'), 'MONTH')
--⇒2016/11/01
FROM
DUAL
More than 5 years have passed since last update.
TRUNC関数の引数に'MONTH'を指定する
SELECT
TRUNC(TO_DATE('2016/11/03', 'YYYY/MM/DD'), 'MONTH')
--⇒2016/11/01
FROM
DUAL
Register as a new user and use Qiita more conveniently