topic Re: Help! Convert a string/timestamp to hours, minutes, seconds in QlikView

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

badzreyes — Wed, 30 Oct 2019 09:42:56 GMT

Hi,

Good day, I have a date column 'Created'

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

sunny_talwar — Wed, 30 Oct 2019 12:34:43 GMT

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

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

Brett_Bleess — Wed, 06 Nov 2019 22:15:39 GMT

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/DateAndTimeFunctions/date-time-functions.htm

Regards,
Brett

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

badzreyes — Thu, 07 Nov 2019 09:38:43 GMT

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!

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

badzreyes — Thu, 07 Nov 2019 09:40:19 GMT

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