Post reply

Select stmt not working

  • February 26, 2010 at 5:51 am

    #137444

    Hi all i m trying to retrieve data from a table which contains from date and

    to date fields but i am trying to retrieve data between certain date but its show only few records not the exact records

    the code is

    SELECT * FROM TIMETRACK WHERE LOGIN BETWEEN '02/11/10' AND '02/26/10

    its showing only 11th dated records

    but actually i have records up to 26th dated

    Please give me solutions

    Thanks in advance

    karthik

  • February 26, 2010 at 6:01 am

    #1125508

    This is because you are not considering the time-part of the date. By default, a date without time is considered as 00:00:00.

    You either need to explicitly add the time-part in the where condition or convert the between clause to comparison clause and by adding a day to todate, i.e.

    SELECT * FROM TIMETRACK WHERE LOGIN BETWEEN '02/11/10 00:00:00' AND '02/26/10 23:59:59 999'

    SELECT * FROM TIMETRACK WHERE LOGIN >= '02/11/10' AND LOGIN < '02/27/10'

    --Ramesh

  • February 26, 2010 at 8:10 am

    #1125604

    For clarity, I like to use the full year YYYY in my dates. It helps prevent any confusion.

  • February 26, 2010 at 9:51 pm

    #1125955

    Hi Ramesh,

    Its working fine now thanks for your help

    Regards

    Karthik

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply