Nick Upson wrote:

> > I'm using 1.5.4, the book says (p157) extract yearday has limits of
> > 1-366 yet the statement below returns 0
> >
> > select extract(yearday from cast('01/01/2007 01:01:01' as timestamp) )
> > from rdb$database
> >

At 09:06 PM 24/09/2007, Alan McDonald wrote:

>maybe check the errata
>seems like it's 0-365

Not caught so far but now is, and the errata have been updated - at
least, the version at
http://www.firebird-books.net/files/ERRATA_1590592794(16).pdf

Timely catch, Nick, as I'm in the process of doing an update for the
supplement...

Thks,
Helen