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,
VicUse 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
>|||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$27813310$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