Using date format

I am creating the report which required to show the response time, my 
calculation of response time like this :

(TIME1 - TIME2)*86400
which will show in second.  

However i realize that if the TIME1 value =
'18-01-2003 00:00:00' (which is mid-night) and TIME2 value = '18-01-2003 
23:55:47', it will show negative figure (-86147).  

Both columns are date format in mytable, is that any way to do it??

Appreciate if you can help me some hint!!

Rgds,
Ngew
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].