5 Replies Latest reply: Jan 11, 2017 9:24 AM by Stefan Wühl RSS

    combine date and hour field?

    ben lim

      I made a mistake at the start, i hope there is a way i can combine on script and not reload all the data again.

       

           Date(floor(Alt(Date,timestamp#(Date,'MM-DD-YYYY hh:mm:ss'))),'DD/MM/YYYY') as Date,

            hour(Alt(Date,Timestamp#(Date,'MM-DD-YYYY hh:mm:ss'))) as Hour,

       

      I have these fields all ready, Date and Hour... i miss the important part which is combining date and hour. (stupid me).

       

      Is there any way i can salvage this by on the loading script, to combine Date and Hour that i have pre-calculated into 01-11-2016 06

      i.e DD-MM-YYYY hh

       

      the reason why i diden want to recalculate because each month has a differne ttime stamp format, i dun wan to go through that hassle again for 5 years of data ;(