On Tuesday 17 July 2007 18:03:43 Dmitri Pissarenko wrote: > Hello! > > One obvious way is to use this: > > SELECT PLACE, SUM(SECOND(DURATION) + > MINUTE(DURATION)*60 + HOUR(DURATION)*60*60) > FROM MyTable > GROUP BY PLACE > > But I still need to convert int to time.
Out of curiosity, what happens if you add this int to the Time 00:00:00? Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Ph: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902
