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

[badzreyes]

Hi,

Good day, I have a date column 'Created'

[sunny_talwar · Accepted solution]

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 ...

[Brett_Bleess · Accepted solution]

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

[badzreyes]

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]

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