You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Renuka Be <re...@gmail.com> on 2015/06/18 12:16:44 UTC

Query in Pattern of string value of Date

Hi Folks,

I have a column with value like "10/05/2012" type of string. I need to
convert this string to timestamp. Is there any way to convert string value
date to specific format.

Regards,
Renuka N

Re: Query in Pattern of string value of Date

Posted by Buntu Dev <bu...@gmail.com>.

Did you already checkout the built-in Date Functions supported by Hive:

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions

Also might want to search for any existing UDFs if the Data Functions does
not satisfy your needs or write one yourself using this guide:
 https://cwiki.apache.org/confluence/display/Hive/HivePlugins

HTH


On Thu, Jun 18, 2015 at 3:46 PM, Renuka Be <re...@gmail.com> wrote:

> Hi Folks,
>
> I have a column with value like "10/05/2012" type of string. I need to
> convert this string to timestamp. Is there any way to convert string value
> date to specific format.
>
> Regards,
> Renuka N
>
>
>
>

Re: Query in Pattern of string value of Date

Posted by si...@avanz.org.

Check this tutorial:
http://snowplowanalytics.com/blog/2013/02/08/writing-hive-udfs-and-serdes

Cheers
Avanz


Quoting Renuka Be <re...@gmail.com>:

> Hi Folks,
>
> I have a column with value like "10/05/2012" type of string. I need to
> convert this string to timestamp. Is there any way to convert string value
> date to specific format.
>
> Regards,
> Renuka N