Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Dates in Hive


Copy link to this message
-
Re: Dates in Hive
I don't have the language manual in frot of me, but I would suggest casting dateint to string, then using the unix_timestamp function. From_unixtime should get it back into a date time string

Matt

On Jun 25, 2012, at 8:05 PM, sonia gehlot <[EMAIL PROTECTED]> wrote:

> Hi All,
>
> A simple question on dates, how can I convert integer column dateint in "yyyymmdd" format to string column in "yyyy-mm-dd" format in hive.
>
> Thanks in advance.
>
> Sonia