![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
![]() |
Tue, May 11 2010 11:49 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Anyone suggest a nice simple easy way to exclude weekends from a datefield BETWEEN start AND end???
Roy Lambert |
Tue, May 11 2010 12:10 PM | Permanent Link |
Uli Becker | Roy,
> Anyone suggest a nice simple easy way to exclude weekends from a datefield BETWEEN start AND end??? Perhaps this link will help: http://ryanfarley.com/blog/archive/2005/02/14/1685.aspx Uli |
Tue, May 11 2010 12:27 PM | Permanent Link |
John Hay | Roy
> Anyone suggest a nice simple easy way to exclude weekends from a datefield BETWEEN start AND end??? where extract(dayofweek from datefield) < 6 John |
Tue, May 11 2010 1:23 PM | Permanent Link |
Roy Lambert NLH Associates ![]() | Uli
As walking the dog and John reminded me Tim's built in a DAYOFWEEK as part of EXTRACT. Thanks for the info though. Roy Lambert |
Tue, May 11 2010 1:24 PM | Permanent Link |
Roy Lambert NLH Associates ![]() | John
Strangely enough that's what came to me whilst walking the dog after stopping work ![]() Roy Lambert |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |