Results 1 to 4 of 4

Thread: Interval Time

  1. #1
    Join Date
    Dec 2008
    Posts
    5

    Unanswered: Interval Time

    i have a table which has date and interval.interval contains hourandminute
    Interval data is every 30 minute interval.for ex 0,30,100,130,200....1200,1230,1300 like this.

    how do i get last 30 minute interval data from select query ?
    Please let me know your thoughts

    Thank you for your help

  2. #2
    Join Date
    Dec 2008
    Posts
    5
    when i query extend(current hour to minute - 40 units minute) i get 2008-12-26 13:31:00.000?
    how do i get the value in hhmm format ?. for ex 1331

  3. #3
    Join Date
    Nov 2008
    Posts
    65
    Provided Answers: 1
    Quote Originally Posted by robiverson
    when i query extend(current hour to minute - 40 units minute) i get 2008-12-26 13:31:00.000?
    how do i get the value in hhmm format ?. for ex 1331
    How about _READING_ this forum?
    http://www.dbforums.com/showpost.php...84&postcount=2

  4. #4
    Join Date
    Nov 2008
    Posts
    65
    Provided Answers: 1
    Quote Originally Posted by robiverson
    i have a table which has date and interval.interval contains hourandminute
    Interval data is every 30 minute interval.for ex 0,30,100,130,200....1200,1230,1300 like this.

    how do i get last 30 minute interval data from select query ?
    Please let me know your thoughts

    Thank you for your help
    What do you mean by "last 30 minute interval data"?

Posting Permissions

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