Re: WEEKDAY и WEEK

Tue, 25 Sep 2007 23:50:05 -0700 

On Wed, 26 Sep 2007 01:18:02 +0400, Kovalenko Dmitry <[EMAIL PROTECTED]> wrote:

> CAST(((EXTRACT(WEEKDAY FROM CAST(('01.01.'||"
> CAST(EXTRACT(YEAR FROM(%1))AS VARCHAR(8)))AS TIMESTAMP))
> EXTRACT(YEARDAY FROM(%1)))/7+1)AS SMALLINT)

(extract(yearday from %1) - extract(weekday from %1) + 1)/7 + 1

-- 
Сергей Смирнов.

Ответить