On Thu, 2 Apr 2015 08:54:46 +0200, "'checkmail' [email protected] [firebird-support]" <[email protected]> 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
