SQL to return a row for each day in a date range

From: Matthew Pascoe (mpascoe_at_stocklogix.com.au)
Date: 10/17/04 

Date: Sun, 17 Oct 2004 09:28:03 +1000

I would like to write an SQL statement that will return a row for each day
that is in a date range that I provide.

For example if the date range is 01-10-04 to 04-10-04 I would like the
following result set:

Day(DateTime data type)
01-10-04
02-10-04
03-10-04
04-10-04

I need to use this as the base for creating a more complex query.

Thanks for any help.

Matthew

Relevant Pages

  • Re: SQL Query
    ... Therefore, God exists. ... A SQL statement begins with "SELECT," ... This means that you are specifying the "Shipping_Group" column of the ... It also means that the "Shipping_Group" column is of a text data type. ...
    (microsoft.public.frontpage.programming)
  • Re: SQL Query
    ... A SQL statement begins with "SELECT," ... alphabetical order. ... This means that you are specifying the "Shipping_Group" column of the ... It also means that the "Shipping_Group" column is of a text data type. ...
    (microsoft.public.frontpage.programming)
  • Possible Oracle 9.2.0.7 performance issue with DBD::Oracles column_info()
    ... My coworkers and I have a question regarding the SQL statement that DBD::Oracle's column_infofunction executes. ... We depend upon column_infoto discover the data type of a large object column is so we can bind it properly. ... While this worked great for us in the past, when we upgraded to Oracle 9.2.0.7 we noticed significant performance drops whenever this method was called. ... A data load test with dbi profiler running showed that column_info's SQL accounts for 78.33% of all dbi calls made during the test. ...
    (perl.dbi.users)
  • Re: Type mismatch
    ... Thanks for the input, question, can the expression of the DMin contain more ... > The third argument of the DateAdd function must be a date data type. ... > DateAdd function does not accept an SQL statement in any of its arguments. ...
    (microsoft.public.access.formscoding)
  • Re: SQL Query
    ... A SQL statement begins with "SELECT," ... alphabetical order. ... This means that you are specifying the "Shipping_Group" column of the ... It also means that the "Shipping_Group" column is of a text data type. ...
    (microsoft.public.frontpage.programming)