3 Replies Latest reply: Apr 9, 2014 2:47 AM by Manish Kachhia RSS

    Problem Converting Timestamp --> Time & Date (Seperate Columns)

    Ram Asokan

      Hi folks,

       

      Issue at hand, please have a look at the images below.

       

      TimeStampProb1.jpg

      In the script, the code used to make the split were:

       

      time(frac(d_create_time),'hh:mm:ss') as Time_MT,

      date(frac(d_create_time),'YYYY-MM-DD') as Date_MT,

       

      When trying to split the column into two, the date values go haywire and its all consistent throughout the whole field showing a the value = "1899-12-30". Please advise. Thanks.

       

      Best Regards,

      R