Results 1 to 8 of 8

Thread: how to query to list range dates

Threaded View

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    May 2013
    Posts
    1,126

    how to query to list range dates

    This involve to table field to query a result but I would like to list in rows a result of sql query between two dates. Im using mysql. I been thinking awhile now, i cant have idea of what statement to use.

    I tried select curdate() as mycurdate where curdate() between '2001-01-01' and '2001-12-31' but I got error statement error.

    I have hoping to have result

    |mycurdate|
    2001-01-01
    2001-01-02
    2001-01-03
    .
    .
    .
    2001-12-31
    Last edited by codesearcher; Jun 12th, 2016 at 01:49 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width