Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Convert the time in string format to hour, minutes and seconds

Hello everyone,

 

I have a time column in the attached file. I would love to break it down to hour, minutes and seconds

Regards

 

 

Labels (4)
1 Solution

Accepted Solutions
kishorj1982
Creator II
Creator II

hour ('09:14:36 AM')

Minute ('09:14:36 AM')

View solution in original post

2 Replies
saurabhwadhwa
Partner - Contributor III
Partner - Contributor III

Hi ,

 

Try like this .

Timestamp(Time , 'hh') as Hours,
Timestamp(Time , 'mm') as Mins,
Timestamp(Time , 'ss') as Seconds

 

BR,

Saurabh

 

kishorj1982
Creator II
Creator II

hour ('09:14:36 AM')

Minute ('09:14:36 AM')