Oracle时间计算 [英] Oracle time calculate

问题描述

亲爱的朋友，

我有一个问题.请解决.

表格内容


Ig_time out_time
08:09:26 16:52:18
08:26:42 16:50:10
08:32:25 18:46:31
08:34:57 18:46:19
09:27:23 10:53:16

我想要区别Ig_date和out_time.

as out_time-ig_time =?

请帮帮我.

问候，
普拉莫德·辛格

HZl Chanderiya

Dear Friend,

I have one problem. Please solve it.

Table Content


Ig_time out_time
08:09:26 16:52:18
08:26:42 16:50:10
08:32:25 18:46:31
08:34:57 18:46:19
09:27:23 10:53:16

I want differences Ig_date and out_time.

as out_time-ig_time = ?

Please Help me.

Regards,
Pramod Singh

HZl Chanderiya

推荐答案

阅读这些内容:

http://www.akadia.com/services/ora_date_time.html [ http://www.orafaq.com/faq/how_does_one_get_the_time_difference_between_two_date_columns [

Read these :

http://www.akadia.com/services/ora_date_time.html[^]

http://www.orafaq.com/faq/how_does_one_get_the_time_difference_between_two_date_columns[^]

这篇关于Oracle时间计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！