Subject | Re: [firebird-support] book error or mine? |
---|---|
Author | Helen Borrie |
Post date | 2006-09-21T23:27:25Z |
At 01:42 AM 22/09/2006, you wrote:
right in the chapter on Date/Time types. (Table 10.10, P.
157). WEEKDAY is actually a zero-based set. To further numb and
confuse you, YEARDAY is 1-based, i.e. Jan 1st does return 1.
./heLen
>If I runYou've found an error in the book. It's wrong on P. 420, though
>
>select current_date, extract(weekday from CURRENT_DATE) from rdb$database;
>
>I get (note I'm in the UK, so dates are dd/mm/yyyy)
>
>21/09/2006, 4
>
>but the book says
>
>"weekday extracts the day of the week (having Sunday = 1, Monday = 2,
>and so on" - which would make thursday return 5.
>
>Have I made a mistake or found a typo (it's not on my type list) ?
right in the chapter on Date/Time types. (Table 10.10, P.
157). WEEKDAY is actually a zero-based set. To further numb and
confuse you, YEARDAY is 1-based, i.e. Jan 1st does return 1.
./heLen