Skip to content
Advertisement

How can a query select dates from only a specific academic year?

This may be simple, but I cannot figure out the correct and simplest way to query a table which contains a date col to return the rows in which the date belongs to the current academic year.

Knowing that for academic year I mean the period from the 1st of September of a year to the 31st of august of the next one, how can you obtain the right dataset from a table that look like this:

Advertisement

Answer

This is an Oracle equivalent of Andomar’s post –

Fiddle: http://sqlfiddle.com/#!4/75a16/1/0

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement