3 Replies Latest reply on Dec 13, 2012 12:50 PM by Jonathan Drummey

    UNIXTIME STAMP to Date conversion

    nitin yadav

      Trying to convert unixtime stamp to Date using DATEADD function like :

       

      DATEADD('second',[trialstart],#January 1,1970# )

      where trialstart is the filed which is unixtimestamp and saved on HIVE as Double data type.

       

      But somehow I am unable to perform the conversion and it says there is some ERROR. The field is constant, but still not able to make the conversion.