info
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
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]
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 );
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
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]"
0 new messages