Something like that?

CREATE PROCEDURE SP_BUILDDATE (ADAY Integer, AMONTH Integer, AYEAR Integer) returns (ADATE Date) AS
BEGIN
ADATE = CAST((ADAY || '.' || AMONTH || '.' || AYEAR) AS DATE);
SUSPEND;
END;


SELECT ADATE FROM SP_BUILDATE(12, 12, 2002);


Regards,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com

> -----Original Message-----
> From: Dieter Tremel [mailto:tremel@...]
> Sent: Thursday, September 26, 2002 5:07 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] build date from integers
>
>
> how can I build a date from integers in a Stored Proc?
>
> Thanks
> Dieter Tremel
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>