Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
badzreyes
Contributor II
Contributor II

Help! Convert a string/timestamp to hours, minutes, seconds

Hi,

Good day, I have a date column 'Created'

2 Solutions

Accepted Solutions
sunny_talwar

Is created read as date field? if it is, then you can try this

LOAD Created,
     Hour(Created) as Hour,
     Minute(Created) as Minute,
     Second(Created) as Second
FROM ...

View solution in original post

Brett_Bleess
Support (Former)
Support (Former)

Carlo, just adding the Help link for things, but if Sunny's post got you what you needed, be sure to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know that worked.  If you are still working on things, leave an update.

Help on date/time functions:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

4 Replies
sunny_talwar

Is created read as date field? if it is, then you can try this

LOAD Created,
     Hour(Created) as Hour,
     Minute(Created) as Minute,
     Second(Created) as Second
FROM ...

View solution in original post

Brett_Bleess
Support (Former)
Support (Former)

Carlo, just adding the Help link for things, but if Sunny's post got you what you needed, be sure to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know that worked.  If you are still working on things, leave an update.

Help on date/time functions:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

badzreyes
Contributor II
Contributor II
Author

thanks for that response! it works, I create fields that separates the date strings into year, month, day, hour, minutes and seconds. have a good day!

badzreyes
Contributor II
Contributor II
Author

Thanks Brett for that reminder, rest assured I'll give an update asap next time. have a good day