Efren Lugo
|
| Posted: 01/07/2003, 3:46 PM |
|
mi data appears like this:
CSIR6 PLAZA MAYOR 2002-12-27 08:13:14.0 2002-12-27 03:51:40.0 0.181643518
CSIR6 PLAZA MAYOR 2002-12-27 08:13:46.0 2002-12-27 08:12:55.0 0.000590277
the last values are the result from a select
select caseid, dstore, entrace_reception, exit_fastrack, entrace_reception - exit_fastrack as difference from iusacell_operation
how can be converted to dates...
|
|
|
 |
RonB
|
| Posted: 01/08/2003, 4:57 AM |
|
Use the to_date and to_char functions:
select caseid, dstore, entrace_reception, exit_fastrack, to_char(to_date(entrace_reception) - to_date(exit_fastrack)) as difference from iusacell_operation
or something like that
Ron
|
|
|
|
|
