List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:August 10 2006 11:15pm
Subject:Re: How to create a table of dates?
View as plain text  
/>So if the date range is '2001-01-15' to '2003-04-01' then it would 
generate
 >approx 800 rows with dates between these 2 ranges. I can't seem to figure
 >out how to do it without writing a program./

See Dates/'Make a calendar table at 
http://www.artfulsoftware.com/queries.php.

PB

-----

mos wrote:
> This one has me puzzled. All I need to do is create a table of dates, 
> one date per row, from a starting to ending date.
>
> So if the date range is '2001-01-15' to '2003-04-01' then it would 
> generate approx 800 rows with dates between these 2 ranges. I can't 
> seem to figure out how to do it without writing a program. Is there a 
> way to generate these rows using just one sql statement? Or am I 
> relegated to writing a program to generate these dates?
>
> TIA
> Mike
>

Attachment: [text/html]
No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.10.8/415 - Release Date: 8/9/2006
Thread
How to create a table of dates?mos10 Aug
  • Re: How to create a table of dates?Peter Brawley11 Aug