Wow...that's fast!!
Thankssss

eLita

--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
<ts@i...> wrote:

> > 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