TimeStamp issue in SQL

[logic4fun]

Hi all,
I have a DB2 timestamp YYYY-MM-DD-HH.MM.SS and i need to pull data by Half Hour Intervals. i know commands Hour(timeStamp) or minute(timeStamp) can give me the data for Hour or Minute . ANY LOGIC for pulling out in HALF HOUR intervals.

thanks in Advance
logic4fun

 

[skypanther]

Try simply dividing mins/30

For mins less than 30, you get a a fraction less than 1. For mins equal 30, you get 1. For mins greater than 30, you get a fraction greater than 1.

So, build your logic with:

if(mins/30 <= 1)
// first half of hour
else if(mins/30 > 1)
// second half of hour

Tim

Skypanther Studios

http://www.skypanther.com