Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012
    Posts
    6

    Unanswered: Working with date

    I want to get the specific range of days. Example

    zzz 2012-08-04 18:41:16.483
    aaa 2012-08-06 08:11:04.713
    bbb 2012-08-07 07:45:23.67
    ccc 2012-08-09 13:21:43.866
    ddd 2012-08-10 10:14:23.353
    eee 2012-08-11 12:53:03.417

    so i only want to get the data from aug 4 to 7.



    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    use either the between construct
    OR
    where MyDateColumn >= and <=

    however as your values also have a time element you will need to use the range
    MyDateColumn between '2012/08/4' and '2012/08/07 23:59:59'
    for an inclusive upper limit
    or MyDateColun >= '2012/08/4' and MyDateColumn< '2012/08/08'
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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