Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Question Unanswered: How to select a time that is within a interval?

    Hi!

    If i have a time and date i an database and want to check if that time and date are within a specified time interval

    like if 2004-08-23 11:00 is within 2004-80-22:11:00 -> 2004-08-24 10:00

    how do i do this?
    Last edited by kuzze; 08-23-04 at 06:40.

  2. #2
    Join Date
    Aug 2004
    Posts
    2
    I solved it by using BETWEEN

    Select ColumnName from TableName where DateColumnName BETWEEN '2004-80-22:11:00' AND '2004-08-24 10:00'

    Thanks to Vijay G

Posting Permissions

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