Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ferha_jafri
Partner - Creator III
Partner - Creator III

how to convert system time to hr

Hello Everyone,

I am facing a problem in converting system time to hours , I tried

time(time#(Now(),'DD/MM/YYYY hh:mm:ss'),'hh') but I am getting the time in hh:mm:ss although I want hours only.Not sure what I am doing wrong.

Thank you

Regards

Ferha

3 Replies
sasiparupudi1
Master III
Master III

Time(Now(1),'hh')

Not applicable

time(now(),'hh')

puttemans
Specialist
Specialist

Hi,

How about Hour('DD/MM/YYYY hh:mm:ss') ?

Regards,

Johan