w3resource

Oracle: Get the first day of the current month

Oracle Datetime: Exercise-1 with Solution

Write a Oracle SQL statement to get the first date of the current month.

Sample Solution:

Oracle Code:

SELECT TRUNC (SYSDATE, 'MONTH') "First day of current month "FROM DUAL;

Output:

  	First day of current month
1	2/1/2021 12:00:00 AM

Improve this sample solution and post your code through Disqus.

Previous: Oracle Datetime Exercises Home
Next: Write a Oracle SQL statement to get the last date of the current month.

What is the difficulty level of this exercise?



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/oracle-exercises/datetime/oracle-datetime-exercise-1.php