extract hour from date

[ceccina]

How can I extract hh:mi from a date filed (dd/mm/yyyy hh:mi) and making time differences?

 

[hoinz]

Have a look at other threads in this forum, e.g. from last week:
thread186-1417322

 

[kskid]

to_char(sysdate,'hh24:mi')

 

[Beilstwh]

It all depends, if you want the time difference between two dates, then simply do some thing like

select sysdate - date_field time_difference
from my_table;

would return the number of days (whole number) and hours/minutes/seconds between the two dates. 1 = 1 day, .5 = 12 hours etc...

Bill
Oracle DBA/Developer
New York State, USA