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