| I want find how many hour,minutes,seconds is taken from task_stared and task_end. [message #632599] |
Tue, 03 February 2015 08:25  |
na.dharma@gmail.com
Messages: 82 Registered: May 2008 Location: bangalore
|
Member |
 
|
|
I want find how many hour,minutes,seconds is taken from task_stared and task_end.
WITH task_started
AS (SELECT 'POP_FS_NEW' AS task_id, '2/2/2015 11:33:28 AM' AS task_started FROM DUAL
UNION
SELECT 'INDEXING_FS_NEW' AS task_id, '2/2/2015 10:08:02 PM' AS task_started FROM DUAL
UNION
SELECT 'STAT_FS_NEW' AS task_id, '2/2/2015 11:45:31 PM' AS task_started FROM DUAL),
task_complete
AS (SELECT 'POP_FS_NEW' AS task_id, '2/2/2015 1:09:04 PM' AS task_complete FROM DUAL
UNION
SELECT 'INDEXING_FS_NEW' AS task_id, '2/2/2015 11:42:42 PM' AS task_complete FROM DUAL
UNION
SELECT 'STAT_FS_NEW' AS task_id, '2/3/2015 10:00:45 AM' AS task_complete FROM DUAL)
SELECT task_started.task_id,
task_started.task_started,
task_complete.task_complete
FROM task_started INNER JOIN task_complete ON task_started.task_id = task_complete.task_id
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|