Discussion Board for collaboration on QlikView Scripting.
I have a time column in the attached file. I would love to break it down to hour, minutes and seconds
Go to Solution.
hour ('09:14:36 AM')
Minute ('09:14:36 AM')
Try like this .
Timestamp(Time , 'hh') as Hours,Timestamp(Time , 'mm') as Mins,Timestamp(Time , 'ss') as Seconds