Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help for calculation Week of date

Status
Not open for further replies.
DATEFUN

DATEFUN

Programmer
Oct 16, 2002
2
US
Hi
Please let me know how to calculate of week of specific date for that month
I don't want week number of the year
I want week of the month

Please help me asap
Thanks
Milind
 
Sort by date Sort by votes
Does the week have to start on a specific day (such as Monday or Sunday)? If not, ceil(To_Number(To_Char(SYSDATE,'DD'))/7) will do it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

deo1
  • Locked
  • Question
Please help with forms6i ole2 ms word
Replies
0
Views
127
deo1
deo1
bookouri
  • Locked
  • Question
replacement for oracle developer forms/reports
Replies
1
Views
174
JimDGr8
JimDGr8
aspiringprog
  • Locked
  • Question
day of week conflicts with Julian date
Replies
2
Views
173
aspiringprog
aspiringprog
deeptic
  • Locked
  • Question
Displaying Date & Time when the form is run
Replies
1
Views
110
sem
sem
faizsaadq
  • Locked
  • Question
How to call crystal reports XI from Oracle Forms 10G
Replies
1
Views
154
oradba101
oradba101

Part and Inventory Search

Sponsor

Back
Top