One problem with that formula is that it fails if you wrap around from one year to the next. But as a quickie, it's good.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine Peter Brawley <[EMAIL PROTECTED]> wrote on 03/22/2005 01:01:29 PM: > Michael, > > Someone on the list recently dave this quickie formula for computing > the no. of biz days:: > > DATEDIFF(date2, date1) - (WEEK(date2) - WEEK(date1)) * 2 > > PB > > ----- > > Stembridge, Michael wrote: > A table exists with id and datetime columns; I need to SELECT records from > the previous business day. I began with this: > > > > SELECT id FROM table WHERE TO_DAYS(NOW()) - TO_DAYS(datetime) <=1 > > > > But if NOW() is a Monday, it pulls records from Sunday (there are none since > records are inserted M-F only). I thought of using something like this in > my WHERE clause: > > > > "AND DAYOFWEEK(datetime) != 6" > > > > Though this doesn't seem like an operable solution (If I'm not mistaken this > would return 0 rows if no records were inserted on a Sunday). > > > > Does MySQL include a specifier for business day? > > > > Thank you, > > Michael > > > > > > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005 > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
