Folks,
Here's a useful one:
CREATE FUNCTION qf_year_quarter (DATETIME) RETURNS VARCHAR AS '
SELECT CAST(CAST(EXTRACT(year FROM $1) AS VARCHAR) || '' Q'' || CAST(EXTRACT (quarter FROM $1) AS VARCHAR) AS
VARCHAR);'
LANGUAGE 'sql';
SELECT qf_year_quarter('1999-11-01'::DATETIME);
--------------
1999 Q4
-Josh
______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete
informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small
businesses fax 621-2533 and non-profit organizations. San Francisco