Subject Re: Date Extraction
Author John Craig
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

> >
> > > EXTRACT (MONTH FROM mydate)
> > > or DAY, YEAR..
> >
> IB 6.0. So Firebird has always had it. The parts you can extract are
> YEAR | YEARDAY| MONTH | DAY | WEEKDAY (from a DATE type)
> and HOUR | MINUTE | SECOND (from a TIME type). You can extract any
> of them from a TIMESTAMP type.
>

So, are goodies like this documented in your The Firebird Book?

Also, is there a slick way to get a textual version of the month or
weekday? January rather than 1, and so on?

John