|
|
| |
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
|
--**************************************
--
-- for :Find week number for a date
--**************************************
--
Give me feedback TO hensen@softhome.net |
code:
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description. |
--**************************************
--
-- Name: Find week number for a date
-- Description:Find week number in month
-- of a specific date
-- By: Hendra Kusumadi
--
-- Inputs:a date
--
-- Returns:week number in a month
--
--This code is copyrighted and has-- limited warranties.Please see http://
-- www.Planet-Source-Code.com/vb/scripts/Sh
-- owCode.asp?txtCodeId=575&lngWId;=5--for details.--**************************************
--
DECLARE @tDate datetime
-- Example date
SET @tDate = '02/01/2002'
-- Week number in a month for a specific
-- date
SELECT (datepart(ww,@tDate)) + 1 - datepart(ww,dateadd(dd,-datepart(dd,@tDate),@tDate)) nWeek | |
| |
| Report Bad Submission |
|
| |
| Your Vote! |
|
See Voting Log |
| |
| Other User Comments |
10/26/2002 2:48:23 AM:
Good........
Hello Oracle Users this
is the Qurey for U...
Select
To_Char(sysdate,'d') from dual
Select
To_Char(sysdate,'dy') from dual
Select
To_Char(Sysdate,'Day') from dual
|
2/10/2003 5:37:51 AM:
wrong
should be
SELECT
(datepart(ww,@tDate)) + 1 -
datepart(ww,dateadd(dd,-(datepart(dd,@tD
ate)-1),@tDate)) nWeek
|
5/27/2003 8:46:48 AM:Nishant
Do you know how to get first day of
week and last day of week for any week
in a year.
|
|
| Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular code, please click here.
|
|
