More specific, you need to use three functions in a row: 1) Use unix_timestamp(string date, string pattern) to convert the date variable, say dt, which you get from a hive query 2) Then use from_unixtime(bigint unixtime) to convert the bigint returned in 1) 3) The use to_date(string timestamp) to convert date-and-time string returned in 2) to just date.
Long story short: Let's say dt is the date returned from your hive query, then this would do the job: to_date(from_unixtime(unix_timestamp(dt,'yyyyMMdd' ) ) ) Keep in mind that MM is capital, in distinguishing from little mm, which is used for minutes, so be careful!! Also, modify the format yyyyMMdd so that it matches the format of the timestamp returned by your hive query. On Mon, Jun 25, 2012 at 10:35 PM, alo alt <wget.n...@googlemail.com> wrote: > > https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-DateFunctions > > -- > Alexander Alten-Lorenz > http://mapredit.blogspot.com > German Hadoop LinkedIn Group: http://goo.gl/N8pCF > > On Jun 26, 2012, at 2:05 AM, sonia gehlot 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 > >
