Re: Using date format

Try
      abs((TIME1 - TIME2)*86400)
this will give you the value without signage.


Regards
Chris Farmer



                                                                                                       
                      "Ngew"                                                                           
                      <[email protected]        To:       "Oracle" <[email protected]>                
                      om>                      cc:                                                     
                                               Subject:  [oracle] Using date format                    
                      24/02/2003 12:41                                                                 
                      Please respond to                                                                
                      "Oracle"                                                                         
                                                                                                       
                                                                                                       




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.unsub%%.






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