1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

How do i create a query to extract all records within a given date. For instance beginning date and?

Discussion in 'SQL - Questions and Answers' started by Richard Amaning, Sep 29, 2006.

  1. Richard Amaning Guest

    Dialect: SQL 92
    Richard Amaning, Sep 29, 2006
    #1

  2. Dimitar Guest

    Dialect: SQL 92
    SQL:

    
select * from t where d between date('2002-01-01') and date('2003-01-01');

    or using intervals:
    SQL:

    
select * from t where d between date('2002-01-01') and date('2002-01-01')+interval 10 month;
    Dimitar, Sep 29, 2006
    #2

Share This Page