OraFAQ Forum: Forms » how to get week number as per financial year starts & end

Home » Developer & Programmer » Forms » how to get week number as per financial year starts & end (oracle )

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

how to get week number as per financial year starts & end [message #395204]

Tue, 31 March 2009 12:08

mohaninforakle
Messages: 55
Registered: January 2009

Member

hai experts,

I have a requirement from my clients,that is i want to get an week number for a particular date,so I used following command to get the week number,like

to_char(datefield,'WW')
this command i used,but my problem is i want to get the week number as per the financial year its starts from March to apirl.That is march 1 to 7 days is a first week and so on.Please help me somebody how to do that.

Report message to a moderator

Re: how to get week number as per financial year starts & end [message #395354 is a reply to message #395204]

Wed, 01 April 2009 03:40

rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon

Senior Member

Try to use the following in a cursor and then fetch to your item

select to_char(<your_date_field>,'iw') - to_char(add_months(trunc(<your_date_field>,'year'),2),'iw') + 1
from dual;

Rajy

Report message to a moderator

Re: how to get week number as per financial year starts & end [message #395410 is a reply to message #395204]

Wed, 01 April 2009 06:08

mohaninforakle
Messages: 55
Registered: January 2009

Member

thanks for your reply

its working fine.

thanks a lot.

Report message to a moderator

Previous Topic:	rerieve updated column name
Next Topic:	connect 6i with MS Access

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 20:37:32 CST 2025