List:General Discussion« Previous MessageNext Message »
From:SGreen Date:March 22 2005 6:00pm
Subject:Re: SELECT rows from the previous business day
View as plain text  
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 <peter.brawley@stripped> 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/mysql?unsub=1
Thread
SELECT rows from the previous business dayMichael Stembridge22 Mar
  • Re: SELECT rows from the previous business dayJigal van Hemert22 Mar
  • Re: SELECT rows from the previous business daySGreen22 Mar
  • Re: SELECT rows from the previous business dayPeter Brawley22 Mar
    • Re: SELECT rows from the previous business daySGreen22 Mar