Hi i am working cognos10 i need no convert Numeric to time datatype
MOdel contain float64 datatype.the value is like
1500
1530
2320
1735
i need to convort this in to time format
15:00
15:30
23:20
17:35
because i need to filter from current_time if the current time is 18:00 then it filter last 4 hour data so the value display between 14:00 and 18:00
and when the current time is 19:00 the value display between 15:00 and 19:00 and so on.
Would it not be easier to convert the current timestamp to a numeric format like:
extract(hour;current_timestamp)*100+extract(minute;current_timestamp)
So the filter would be:
[numerictime] > extract(hour;current_timestamp)*100+extract(minute;current_timestamp) - 400