help needed on datetime functions

hi everybody i want to take diff of datetime format columns. Is it possible using direct '-' arithmatic.. It gives result as: 2001-11-03 15:43:47 - 2001-11-03 15:42:21 = 126 2001-11-03 16:11:50 - 2001-11-03 15:48:00 = 6350 First row is clear but i'm not getting second row's diff.. **((63)50)**

Re: help needed on datetime functions

On Wednesday 05 December 2001 16:40, you wrote: hi everybody i want to take diff of datetime format columns. Is it possible using direct '-' arithmatic.. It gives result as: 2001-11-03 15:43:47 - 2001-11-03 15:42:21 = 126 2001-11-03 16:11:50 - 2001-11-03 15:48:00 = 6350 First row is