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
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.