Hello, Newbie SQL person here. I am hoping to be able to do the following. Given two dates, I would like to display all of the days between them.
So if I had the dates 2002-02-08 and 2002-02-12, I would like to have MySQL spit back 2002-02-08 2002-02-09 2002-02-10 2002-02-11 2002-02-12 Any way I can do this directly in MySQL without constructing a table? I've looked through the date maniplulation routines in the manual, but nothing jumps out at me. Any pointers would be appreciated. I know how I could do this in Perl or PHP, but I was hoping to get it done directly in SQL. Temp table? Thanks Tim Tim Carlson Voice: (509) 376 3423 Email: [EMAIL PROTECTED] EMSL UNIX System Support --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
