Hive, mail # user - Get only the date from DateType data

Get only the date from DateType data

Raihan Jamal 2012-07-18, 21:48

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*

Re: Get only the date from DateType data

Raihan Jamal 2012-07-18, 21:55

And CREATED_TIME is string data type.
*Raihan Jamal*

On Wed, Jul 18, 2012 at 2:48 PM, Raihan Jamal <[EMAIL PROTECTED]> 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*
>
>

Re: Get only the date from DateType data

Vijay 2012-07-18, 22:49

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 <[EMAIL PROTECTED]> wrote:
> And CREATED_TIME is string data type.
>
>
>
>
> Raihan Jamal
>
>
>
> On Wed, Jul 18, 2012 at 2:48 PM, Raihan Jamal <[EMAIL PROTECTED]> 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
>>
>