Hi,

> Good day
> =-=-=-=-==-
>
> I would like to know what is regarded as a stable production UDF that can be used
> to exstract the day of week (dow) and the day of month and also the year and the month
> integer values from a date or timestamp field.

From what I see, you don't necessarily need an UDF. The built-in
EXTRACT(...) should do what you want.

- day of week (dow)

EXTRACT(WEEKDAY FROM DATECOLUMN)

- day of month

EXTRACT(DAY FROM DATECOLUMN)

- month and year

EXTRACT(MONTH FROM DATECOLUMN)
EXTRACT(YEAR FROM DATECOLUMN)


If you need something different, then come back and we'll see
what UDF library fits you best.


Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com