> How to get the number of days in a month (30 or 31 or 28 or 29) from a
> date given?
>
> let say the date is 06-OCT-2004, it should return 31 days..

Either via an UDF or you could have a look here:

http://www.volny.cz/iprenosil/interbase/ip_ib_code_timestamp.htm

Scroll down to the "Number of days in month" section.



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