![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Extensions » View Thread |
Messages 1 to 1 of 1 total |
![]() |
Mon, Feb 6 2012 8:58 AM | Permanent Link |
Lucian | CREATE FUNCTION "IsCurWeek" (
IN "ADate" DATE) RETURNS BOOLEAN BEGIN DECLARE Result BOOLEAN DEFAULT False; DECLARE EndDate, StartDate, Temp DATE; DECLARE iYear, iMonth, iDay, iDOW INTEGER; SET EndDate = CURRENT_DATE; SET iDOW = EXTRACT(DAYOFWEEK, EndDate); SET Temp = EndDate - CAST(iDOW AS INTERVAL DAY); SET iYear = EXTRACT(YEAR, Temp); SET iMonth = EXTRACT(MONTH, Temp); SET iDay = EXTRACT(DAY, Temp); SET StartDate = CAST(CAST(iYear AS VARCHAR) + '-' + CAST(iMonth AS VARCHAR) + '-' + CAST(iDay AS VARCHAR) AS DATE); IF ADate BETWEEN StartDate AND EndDate THEN SET Result = True; ELSE SET Result = False; END IF; RETURN Result; END DESCRIPTION 'Boolean function to return TRUE if the given date belongs to current week.' |
This web page was last updated on Saturday, June 22, 2024 at 05:51 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |