hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ruslan Al-Fakikh <metarus...@gmail.com>
Subject Re: how to transform the date format in hive?
Date Thu, 22 Nov 2012 11:57:24 GMT
Hi, also take a look at Hive date functions:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions


On Thu, Nov 22, 2012 at 3:59 AM, Tom Hubina <tom@z2live.com> wrote:

> Could convert them to unix time which will give you two bigints that you
> can subtract to get seconds, and divide result by 60 to get minutes, etc.
>
> Tom
>
>
> On Wed, Nov 21, 2012 at 3:15 PM, qiaoresearcher <qiaoresearcher@gmail.com>wrote:
>
>> Hi All,
>>
>> Assume we have two time stamp like:    9/15/2002  8:05   and    9/15/2002
>>   9:05
>>
>> if we need to evaluate the difference of these two time stamp in terms of
>> hours ( or minutes ), how to do that?
>>
>> Hive seems only support the format  'yyyy-MM-dd HH:mm:ss' , how can we
>> transform the two time stamps into the format that can be processed by
>> hive?
>>
>> thanks for any suggestion in advance.
>>
>>
>>
>

Mime
View raw message