Subject | Re: Number od days in selected month |
---|---|
Author | majstoru |
Post date | 2006-08-07T11:53:09Z |
--- In firebird-support@yahoogroups.com, "Ivan
Prenosil" <Ivan.Prenosil@...> wrote:
Prenosil" <Ivan.Prenosil@...> wrote:
> You can use it directlyThank you Ivan, that is I want to do!
>
> SELECT
> EXTRACT(DAY FROM (MyDate - EXTRACT(DAY FROM MyDate) + 32
> - EXTRACT(DAY FROM MyDate - EXTRACT(DAY FROM MyDate) + 32)))
> FROM MyTable;
>
> or store that expression into computed column.
>