Thanks I believe this will help.

Thanks again

johannes

At 10:17 20/07/2004, you wrote:

>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
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004


[Non-text portions of this message have been removed]