How to bring India financial years base on month using SQL select query

Question

User-471420332 posted

I need financial year like below format, in India financial year runs from 1 April to 31 March in every year.

1. Example 1 <gwmw class="ginger-module-highlighter-mistake-type-1" id="gwmw-15808821173586221311272">april</gwmw> 2018 to 31 march 2019 (2018-2019)
2. Example 1 <gwmw class="ginger-module-highlighter-mistake-type-1" id="gwmw-15808821173603055643187">april</gwmw> 2019 to 31 march 2020 (2019-2020)

I want below output and select query <gwmw class="ginger-module-highlighter-mistake-type-3" id="gwmw-15808821173622452077317">need</gwmw> below columns from 2018 to <gwmw class="ginger-module-highlighter-mistake-type-3" id="gwmw-15808821173626693713273">currently</gwmw> date, if the new April month starts then again new dropdown value should come, example 2020 year past then if current month April 2021 then the new dropdown value 2021-2022 should come like that <gwmw class="ginger-module-highlighter-mistake-type-1" id="gwmw-15808821173627913224186">so on</gwmw>.

Year       <gwmw class="ginger-module-highlighter-mistake-type-1" id="gwmw-15808821177721981095960">FinancialYear</gwmw>
2018       2018-2019 
2019       2019-2020

Answer 1

User475983607 posted

In my experience, this problem is solved by adding a record to a table.

Are you having difficulty writing a record to a database, reading a record, populating a select, finding the current day, month, year? Share your code and explain what problem you are having.