Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Coverttolocaltime

Hi All,

I am trying to convert the format 29/08/2015 03:05:37 to time only but the problem is that I need to add 4 hours to it so that it reflect GMT+04:00.

So my answer should be 07:05:37.

My current line i my loading script is as below:

Time(Frac([createdtime]), 'hh:mm:ss') as Time,

Kind Regards,

Hasvine

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Something like :

     Time(Frac([createdtime]) + (4/24) , 'hh:mm:ss') as Time,

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Something like :

     Time(Frac([createdtime]) + (4/24) , 'hh:mm:ss') as Time,

MK_QSL
MVP
MVP

=Time(Frac(TimeStamp#('29/08/2015 03:05:37','DD/MM/YYYY hh:mm:ss')) + Time#('4','h'))

Anonymous
Not applicable
Author

Not applicable
Author

Thank you all.

KR,

Hasvine