Archives of the TeradataForum
Message Posted: Thu, 07 Jan 2016 @ 13:27:04 GMT
Some of our user reports are defined based on Fiscalweek extraction from current date.
In most of the reports WEEK(CURRENT_DATE) is used and it?s now giving incorrect results.
sel WEEK(CURRENT_DATE) .
This function is returning the current week as 2, which is not True.
Whereas, if I use
sel WEEKNUMBER_OF_YEAR (current_date)
the output is 1. --> FW 1. (which is true). My assumption is both the functions should return the output as 1. Can you please clarify?
Also, just curious to know how these results are fetched from the database?
Sel user Sel time Select date sel WEEKNUMBER_OF_YEAR (current_date) DB version: ?TD 14.10 (14.10.06.03_d2d ? patch)
Sravan Kumar Bodla
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|