OraFAQ Forum: SQL & PL/SQL » how to find data using date as a parameter in financial year

Home » SQL & PL/SQL » SQL & PL/SQL » how to find data using date as a parameter in financial year

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to find data using date as a parameter in financial year [message #610309]

Wed, 19 March 2014 05:49

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

i have one table and there is a column which is of date datatype.
i want to fetch data from the table for particular financial year.
the financial year starts from 1 april and ends on 31st march.

how to do that.
thanks

Report message to a moderator

Re: how to find data using date as a parameter in financial year [message #610310 is a reply to message #610309]

Wed, 19 March 2014 05:54

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

If you know when the financial year starts and ends, what's wrong with the obvious:

WHERE date_col between <start_date> and <end_date>

Report message to a moderator

Previous Topic:	SQL solution needed - urgent!
Next Topic:	I Object to that Cursor record!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 08:12:39 CDT 2024