hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vijay <tec...@gmail.com>
Subject Re: Get only the date from DateType data
Date Wed, 18 Jul 2012 22:49:38 GMT
string to_date(string timestamp) does the trick.

The official hive UDF page has all the useful functions that are available:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF

-Vijay

On Wed, Jul 18, 2012 at 2:55 PM, Raihan Jamal <jamalraihan@gmail.com> wrote:
> And CREATED_TIME is string data type.
>
>
>
>
> Raihan Jamal
>
>
>
> On Wed, Jul 18, 2012 at 2:48 PM, Raihan Jamal <jamalraihan@gmail.com> wrote:
>>
>> This is the CREATED_TIME 2009-12-14 10:15:54
>>
>> How I can get only the date part from the above created_time, just like
>> below.
>>
>> 2009-12-14
>>
>> Any suggestions will be appreciated.
>>
>>
>> Raihan Jamal
>>
>

Mime
View raw message