Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Extensions » View Thread |
Messages 1 to 2 of 2 total |
LIB - func - IsLastYear.sql |
Mon, Feb 6 2012 12:26 PM | Permanent Link |
Lucian | CREATE FUNCTION "IsLastYear" (
IN "ADate" DATE) RETURNS BOOLEAN BEGIN DECLARE Result BOOLEAN DEFAULT False; DECLARE EndDate, StartDate DATE; DECLARE iYear INTEGER; SET EndDate = CURRENT_DATE; SET iYear = EXTRACT(YEAR, EndDate)-1; SET StartDate = CAST(CAST(iYear AS VARCHAR) + '-01-01' AS DATE); SET EndDate = CAST(CAST(iYear AS VARCHAR) + '-12-31' 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 last year.' |
Wed, Feb 8 2012 3:18 AM | Permanent Link |
David Cornelius Cornelius Concepts | There are some nice shortcuts in EDB. Consider this alternative.
CREATE FUNCTION "IsLastYear" (IN "ADate" DATE) RETURNS BOOLEAN BEGIN RETURN (EXTRACT(YEAR FROM ADate) = EXTRACT(YEAR FROM CURRENT_DATE) - 1); END |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |