Need Help

[zee1527]

Hi Friends

I need a help i design a form for sign in and sign out,
i make to field for timing can you help me to substract time like i want to minus time1 from time2 in the reports
i'll really thankful for your help or tell me how to minus(substracts time)

 

[sem]

You may subtract dates explicitly. The result will be in days.

Regards, Dima

 

[zee1527]

Sem i want to substract time can you tell me how i do that with the example thanks

 

[sem]

declare
start_date DATE := sysdate;
end_date DATE := to_date('01.01.04','dd.mm.rr');
interval_in_seconds number;
begin
interval_in_seconds := (end_date-start_date)*24*60*60;
end;

Regards, Dima

 

[zee1527]

Sem can you tell me how i substract time instead of date like 3:40pm - 4:40 pm thanks alot please help me

 

[sem]

I can not understand your question: DATE in Oracle holds both date and time information. You may subtract a value of date truncated to days to obtain only time part (again in days).

Regards, Dima

 

[zee1527]

Thanks Sem for your help
sem can you please help me in this situation
i am creating a sign in and sign out form
i want to make a field for TIME like at which time that person sign in in the same way i do it for sign out what i want now is to substract signin time with sign out time in the reports please help me if you want more inforatioin please email me its urgent