Interval Time

robiverson · #1 (**permalink**) 12-26-08, 13:02

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

robiverson · #2 (**permalink**) 12-26-08, 14:13

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

ibm.ids · #3 (**permalink**) 12-26-08, 20:09

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

ibm.ids · #4 (**permalink**) 12-26-08, 20:10

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"?