Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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
Partner

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')

View solution in original post