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 <sonia.geh...@gmail.com> 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
