Hi All,

I have a column(ex:Received_date) of type datetime. I want to find the number of hours in between the current datetime and Received_date.
Thanks in Advance.

What's your format of datetime?(which time units it contains-(year,month, ...)
?

Format: DATETIME YEAR TO FRACTION(5) (eg., 2008-11-18 07:01:45.000)

Need a query will give the result like the below example,

Received_date: 2008-11-17 07:01:45.000
Current datetime: 2008-11-18 07:01:45.000
Result(Difference in hours) : 24 hrs

Something like this:

create table test_date_time(
dt1 datetime year to fraction(5),
dt2 datetime year to fraction(5)
);
insert into test_date_time values("2008-11-17 07:01:45.000", "2008-11-18 07:01:45.000");

select (dt2 - dt1)::interval hour to hour from test_date_time;

drop table test_date_time;

As you can see, result from DATETIME - DATETIME is INTERVAL and you can CAST it on precision you want.
HTH