Monday , October 7 2024

EOMONTH Function in SQL Server(TSQL)

You can find the last day of a month using EOMONTH function. In addition, you can use a second parameter that add a specific number of month to the specified value by the first parameter. The second parameter is optional.

EOMONTH with only first parameter:

EOMONTH with two parameter:

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories