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

Datetime-functions

Are there some functions to compare two datetimes-fields (like if one if „greater“ the the other or a function which says, who many seconds are between two datetimes) ? Martin - Before posting, please check: