#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Posts
    1
    Rep Power
    0

    Select Product based on date


    Hai,




    Product Date
    --------------------------------------------------------
    pd0 2012-08-11 18:45:55.780
    Pd1 2012-08-11 18:55:17.020
    pd2 2012-08-11 19:06:58.623
    pd3 2012-08-18 12:00:01.193
    pd4 2012-08-25 12:13:04.077
    pd5 2012-08-25 17:28:30.347
    pd6 2012-08-25 18:23:16.473
    pd7 2012-09-18 18:29:58.360


    I want select the product based on from date and to date.

    For Example

    I want the select the product date in between 2012-08-11 to 2012-08-18

    Note:dont check the time.

    I want the query for select product based on only date not depend upon time
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,207
    Rep Power
    4279
    Originally Posted by sidharthgs6
    ...in between 2012-08-11 to 2012-08-18
    please define "in between"

    are rows from 2012-08-11 included or not?

    are rows from 2012-08-18 included or not?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo