simple question

------_=_NextPart_001_01C3CEFA.340B1D72
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

TXkgSW5ub0RCIGZpbGVzIG9uIG15IHN5c3RlbSBoYXZlIGdvdHRlbiB0b28g YmlnLCBhbmQgc28g
SSd2ZSBkcm9wcGVkIHNldmVyYWwgb2YgdGhlIGxhcmdlIHRhYmxlcyB0aGF0 IEkgIG5vIGxvbmdl
ciBuZWVkLiAgSG93IGRvIEkgcmVxdWVzdCBJbm5vREIgdG8gcmVkdWNlIGl0 J3MgZmlsZSBzaXpl
IGNvbnNpc3RlbnQgd2l0aCB0aGUgbmV3IGRhdGEgc3RydWN0dXJlPw0KIA0K Q2hyaXMNCg0KDQoq
KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioq
KioqKioqKioqKioqDQpUaGlzIGUtbWFpbCBpcyB0aGUgcHJvcGVydHkgb2Yg RW5yb24gQ29ycC4g
YW5kL29yIGl0cyByZWxldmFudCBhZmZpbGlhdGUgYW5kIG1heSBjb250YWlu IGNvbmZpZGVudGlh
bCBhbmQgcHJpdmlsZWdlZCBtYXRlcmlhbCBmb3IgdGhlIHNvbGUgdXNlIG9m IHRoZSBpbnRlbmRl
ZCByZWNpcGllbnQgKHMpLiBBbnkgcmV2aWV3LCB1c2UsIGRpc3RyaWJ1dGlv biBvciBkaXNjbG9z
dXJlIGJ5IG90aGVycyBpcyBzdHJpY3RseSBwcm9oaWJpdGVkLiBJZiB5b3Ug YXJlIG5vdCB0aGUg
aW50ZW5kZWQgcmVjaXBpZW50IChvciBhdXRob3JpemVkIHRvIHJlY2VpdmUg Zm9yIHRoZSByZWNp
cGllbnQpLCBwbGVhc2UgY29udGFjdCB0aGUgc2VuZGVyIG9yIHJlcGx5IHRv IEVucm9uIENvcnAu
IGF0IGVucm9uLm1lc3NhZ2luZy5hZG1pbmlzdHJhdGlvbkBlbnJvbi5jb20g YW5kIGRlbGV0ZSBh
bGwgY29waWVzIG9mIHRoZSBtZXNzYWdlLiBUaGlzIGUtbWFpbCAoYW5kIGFu eSBhdHRhY2htZW50
cyBoZXJldG8pIGFyZSBub3QgaW50ZW5kZWQgdG8gYmUgYW4gb2ZmZXIgKG9y IGFuIGFjY2VwdGFu
Y2UpIGFuZCBkbyBub3QgY3JlYXRlIG9yIGV2aWRlbmNlIGEgYmluZGluZyBh bmQgZW5mb3JjZWFi
bGUgY29udHJhY3QgYmV0d2VlbiBFbnJvbiBDb3JwLiAob3IgYW55IG9mIGl0 cyBhZmZpbGlhdGVz
KSBhbmQgdGhlIGludGVuZGVkIHJlY2lwaWVudCBvciBhbnkgb3RoZXIgcGFy dHksIGFuZCBtYXkg
bm90IGJlIHJlbGllZCBvbiBieSBhbnlvbmUgYXMgdGhlIGJhc2lzIG9mIGEg Y29udHJhY3QgYnkg
ZXN0b3BwZWwgb3Igb3RoZXJ3aXNlLiBUaGFuayB5b3UuIA0KKioqKioqKioq KioqKioqKioqKioq
KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKg0KDQo=

------_=_NextPart_001_01C3CEFA.340B1D72--

RE: simple question

I would thing that given: -
- the day of week of the start date
- the day of week of the finish date
- the number of weeks between the start and finish dates
You could create some logic to figure how many, say Tuesdays, occur between
the two dates.
If there are 10 whole weeks then there would be at least 10 Tuesdays. There
may be, I think, at most one more depending on the day of week of the start
and finish. It might be that you only add one if both the start and finish
are Tuesdays. You certainly don't need a database to answer this question!

The MS DateDiff functions can give you date differences in weeks and I am
sure there are equivalent functions on other systems. Anyway you can always
find the days between two dates and divide by seven to get the answer.

John B.

-----Original Message-----
From: ascll [mailto:ascll@yahoo.com]
Sent: Saturday, 26 November 2005 12:38 AM
To: win32@ lists.mysql.com
Subject: simple question

Greetings,

How to we know how many Tuesday within a predefined
time frames, say

Number of Monday between 1 Jan 2005 until 31 Aug 2005
OR
How many Saturday between 13 Feb 2005 until 17 May
2005

Thanks.




__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org