On Thu, 2 Apr 2015 08:54:46 +0200, "'checkmail' check_mail@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:

> is there an easy way to get all days from a month? I would like to

insert

> all days from a month and not every month has 31 days :)

Not that I know.

> If not, I can create a stored Procedure who checked if the date is

possible

> and returns me if is okay or not.
>
> Then is there a function available to get the weekday of the day without
> freeadhocudfdll? From Monday to Sunday in terms of 1 to 7 or so.

EXTRACT(WEEKDAY FROM ...), see
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-extract.html
but it takes Sunday as the first day of the week instead of Monday, so you
need to shift/fix it yourself.

Mark