http://www.google.com/search?sourceid=navclient
<http://www.google.com/search?sourceid=navclient&ie=UTF-8&oe=UTF-8&q=sql+ser
ver+business+day> &ie=UTF-8&oe=UTF-8&q=sql+server+business+day
Basically the trick is you need a function that gives you the day of week of
a date. This varies from dbms to dbms.
Or you can calculate it yourself - the formula looks pretty easy:
http://www.bsdg.org/swag/DATETIME/0027.PAS.html
-----Original Message-----
From: Eric Hoffman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 22 October 2003 1:44 p.m.
To: CF-Talk
Subject: RE: Select by business day in SQL
That just slams me back to the home page...is there a tutorial on such in
the SQL Section or otherwhere?
Regards,
Eric
"The reasonable man adapts himself to the world; the unreasonable one
persists in trying to adapt the world to himself. Therefore all
progress depends on the unreasonable man."
-- George Bernard Shaw
_____
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 8:38 PM
To: CF-Talk
Depends on the DBMS, but check this out:
http://www.informit.com/isapi/product_id~%7B1FFCD51E-9DDE-4C48-98C9-A6635EE2
E5CB%7D/element_id~%7B70A2AF7C-F062-41CF-98DF-3B592737B231%7D/st~%7B340C91CD
-6221-4982-8F32-4A0A9A8CF080%7D/content/articlex.asp
-----Original Message-----
From: Eric Hoffman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 22 October 2003 1:24 p.m.
To: CF-Talk
Subject: Select by business day in SQL
Anyone have any earthly idea how to figure out how I can search a database
log file, and just pull things out based upon activity during a business day
(m-f)?
Thanks for any ideas....
Regards,
Eric J. Hoffman
DataStream Connexion
www.datastreamconnexion.com
_____
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
