hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Babe Ruth <>
Subject RE: Determining DateDiff By Minutes in Hive
Date Wed, 05 Dec 2012 21:37:07 GMT

this seems to be only for day,  I was wondering how to determine if a record is within 15
minutes of a previous record 

Date: Wed, 5 Dec 2012 12:53:27 -0800
Subject: Re: Determining DateDiff By Minutes in Hive

George,There is a datediff UDF which will tell you the difference between 2 dates.

You can find the number of minutes with simple arithmetic. Keep in mind that this method would
not account for lost (or gained) minutes due to day light savings time. If that's important,
it will be best to convert precise timestamps to UTC and then subtract them.

On Wed, Dec 5, 2012 at 12:33 PM, Babe Ruth <> wrote:

Hello All,
I would like to find the total amount of minutes between two dates.  Not sure if this is possible
in hive.  Any help would be great.


View raw message