subtraction on datetime fields

[Tom Roos]

hi

i want to build a query in which i have 2 datetime fields which i subtract from one another. what is the result set? is it in (milli)seconds, is it a unix timestamp? what type of convertion do i have to apply to report the difference in minutes?

tks
tom






_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php