Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to get number of saturday and sunday for spesified date range

20 views
Skip to first unread message

Teddy

unread,
Jan 31, 2008, 2:29:41 AM1/31/08
to
Dear All,

How to get number of saturday and sunday for spesified date
range? example ..
range 2007-12-14 to 2008-01-29, how many saturday and sunday
are there? ..

Thanks a lot in advance

Regards
Teddy

Breck Carter [Team iAnywhere]

unread,
Jan 31, 2008, 8:23:58 AM1/31/08
to
SELECT COUNT(*)
FROM ( SELECT DATEADD (
DAY, day_generator.row_num, '2007-12-14' )
AS generated_date
FROM sa_rowgenerator (
0, DATEDIFF ( DAY, '2007-12-14', '2008-01-29' ) )
AS day_generator )
AS date_generator
WHERE DOW ( date_generator.generated_date ) IN ( 1, 7 );

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck....@risingroad.com

Roger Peffers

unread,
Feb 2, 2008, 4:49:09 AM2/2/08
to
Hi Breck

When I run your script in 9.0.2 I get an error 'procedure
sa_rowgenetrator not found'

What am I missing?

Thanks

Roger


On Feb 1, 2:23 am, "Breck Carter [Team iAnywhere]"

> breck.car...@risingroad.com

0 new messages