Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
akpofureenughwu
Contributor 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
Contributor II

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

hour ('09:14:36 AM')

Minute ('09:14:36 AM')

2 Replies
Partner
Partner

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

Hi ,

 

Try like this .

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

 

BR,

Saurabh

 

kishorj1982
Contributor II

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

hour ('09:14:36 AM')

Minute ('09:14:36 AM')