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;
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: 64130
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
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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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
Previous Topic: does this need a union?
Next Topic: basic and urgent
Goto Forum:
  


Current Time: Wed Dec 07 09:00:16 CST 2016

Total time taken to generate the page: 0.14966 seconds