Home » Other » Training & Certification » counting weekdays since birthday
counting weekdays since birthday [message #275814] Mon, 22 October 2007 15:32 Go to next message
Duke
Messages: 14
Registered: August 2006
Junior Member
Ok say... i am a bit of an workaholic,
and i want to count the weekdays since my birhday, to count the days I could have been working.....

How would I do this,

Something like

select username,dateofbirth, ..... from users;

Report message to a moderator

Re: counting weekdays since birthday [message #275849 is a reply to message #275814] Tue, 23 October 2007 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What did you try or search till now?
This has been asked many times, so answer is already there.

By the way: always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Re: counting weekdays since birthday [message #275853 is a reply to message #275814] Tue, 23 October 2007 01:13 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Quote:

workaholic
If so, you could have got the answer till now.
Quote:

since my birhday, to count the days I could have been working.....
Oh! you have been working since your birth day!!

Anyway, does the following works for you?
1. get the days (sysdate - DOB)
2. convert them into weeks (divide the above by 7)
3. multiply with 5. I assume you have worked on holidays also, as you are a workaholic.

By
Vamsi

Report message to a moderator

Previous Topic: does this need a union?
Next Topic: basic and urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 12:34:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.