How to convert a timestamp to the nearest minute?

[josephinetedesc]

I have a problem:

I have a series of events that occur within a number of milliseconds of each other.

How do I show all the timestamps that occur within the same MINUTE   - Perhaps I need to do it in SQL before it gets to QlikView?

Jo

[MarcoWedel]

see also

http://qlikviewcookbook.com/2011/10/correct-time-arithmetic/