Oracle is used on the first day, and Oracle is used on the first day.
Although I have already studied Oracle in the first half of the year, I have never practiced it in the experiment class. I feel that I have had a good time before!
In my opinion, Oracle is as difficult as an engineer building the largest hospital in Asia, such as a doctor's 99% failure rate;
This time I had to do it, and the irresistible charm overwhelmed me.
It would be nice if there are various great gods to help you!
So far, I have installed the Oracle and Oracle visual interface software Navicat for oracle and connected to it!
(Life is a painting, and whether this painting can be left or not depends on your life !)
Oracle obtains the first day of the current year
Select trunc (SYSDATE, 'yyyy') from dual;
You can obtain the first day of the current year.
You can search for the TRUNC function by Baidu.
How Does ORACLE specify the date as the first day of the current month?
The where condition can be written in this way.
Substr ('20140901', 20120525) = '01'
'20140901' can be replaced with a date field and converted to a char type using to_char.