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.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme