DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to find records with minutes range.

  1. #1
    Join Date
    Nov 2008
    Posts
    1

    How to find records with minutes range.

    Hi Experts,

    I need to find records with following ranges.

    18 Nov 2009 10:00:00 to 19 Nov 2008 10:00:00.

    could you please suggest me the sql.

    Thanks in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    where date_column between 18 Nov 2008 10:00:00 and 19 Nov 2008 10:00:00

  3. #3
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    where start_date between to_date('18-NOV-08 10:00:00','DD-MON-YY HH24:MI:SS') and to_date('19-NOV-08 10:00:00','DD-MON-YY HH24:MI:SS')
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  4. #4
    Join Date
    Nov 2008
    Posts
    4

    Thumbs up Re :

    select * from Table Name where date_column between 18 Nov 2008 10:00:00 and 19 Nov 2008 10:00:00

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by nisarg
    select * from Table Name where date_column between 18 Nov 2008 10:00:00 and 19 Nov 2008 10:00:00
    why have you posted what 2 others have already done

Posting Permissions

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


Click Here to Expand Forum to Full Width