CREATE FUNCTION "IsSecondHalfOfYear" (
IN "ADate" DATE)
RETURNS BOOLEAN
BEGIN
 DECLARE Result BOOLEAN DEFAULT False;
 DECLARE EndDate, StartDate DATE;
 DECLARE iYear INTEGER;

 SET iYear = EXTRACT(YEAR, ADate);
 SET StartDate = CAST(CAST(iYear AS VARCHAR) + '-07-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 is belongs to second half of its year.'