|
Home > Archive > MS SQL Server > March 2005 > Date query question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Date query question
|
|
|
| Is there a way to run a query or a function that will
return every Saturday of the specified year in mm/dd/yyyy
format?
TIA,
Vic
| |
|
| Use DATEPART():
-- if you are using default setting
SELECT date FROM table
WHERE DATEPART(dw, date) = 7
"Vic" wrote:
> Is there a way to run a query or a function that will
> return every Saturday of the specified year in mm/dd/yyyy
> format?
>
> TIA,
> Vic
>
| |
| Aaron [SQL Server MVP] 2005-03-31, 8:01 pm |
| http://www.aspfaq.com/2519
(Locale-specific format is the job of the presentation layer, btw, and
mm/dd/yyyy is not the best choice.)
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Vic" <vduran@specpro-inc.com> wrote in message
news:02de01c5361c$27
813310$a501280a@phx.gbl...
> Is there a way to run a query or a function that will
> return every Saturday of the specified year in mm/dd/yyyy
> format?
>
> TIA,
> Vic
|
|
|
|
|