Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2001

    Unanswered: Date from Date/Time Field

    I have what I'm assuming is an easy question to answer, but I haven't found the answer yet.

    I am storing date and time info in a SmallDateTime field. The problem is when I try to retrieve records for a specific date.

    For example,

    "SELECT field_date FROM table WHERE field_date = '4/15/2002';"

    This SQL statement returns no data. I'm assuming it's looking for an exact match, which it won't find due to the time info.

    I tried to use LIKE, but SQL Server didn't like LIKE.

    How do I retrieve records by date only?


  2. #2
    Join Date
    Feb 2002
    Houston, TX
    three options:

    store the dates without time, essentialy making the time part midnight.

    convert "field_date" to a string, this can be slow as you will scan the entire table.

    change the where caluse to search using between "where filed_date between '4/15/2002' and '4/15/2002 23:59:59:999'"
    Last edited by Paul Young; 04-15-02 at 13:48.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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