#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Iran
    Posts
    3
    Rep Power
    0

    Comparison with two date


    Hello all:
    I want to retrieve some data between two date for example I want to get all of the students between 2002/4/7 and 2003/8/8.How should I write the sql ?
    thank you very much Mohsen
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    5
    Rep Power
    0
    SELECT col1, col2, col3, ... FROM students WHERE date1 >= 20020407 AND date1 <= 20030808

    That's one way to do it.

IMN logo majestic logo threadwatch logo seochat tools logo