Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bbmmouha
Creator
Creator

how to convert linux date to only minutes

hello

how to convert linux date to only minutes DD/MM/YYYY hh:mm

i didn't get it it work with second but in minutes this did't work

thanks for your helps

12 Replies
Anil_Babu_Samineni

If you are working for full timestamp you need to format to accordingly. What are you trying using master calendar? You want to populate all missed values from seconds or minutes or dates?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
bbmmouha
Creator
Creator
Author

i try to use the master calendar and populate up to minutes only

bbmmouha
Creator
Creator
Author

the trick is that when i use TimeStamp(Makedate(1970,1,1)+ date_order /24/60/60 ,'DD/MM/YYYY hh:mm' ) it display in minutes but still join in second

i modified it to  Timestamp#(TimeStamp(Makedate(1970,1,1)+ date_order /24/60/60 ,'DD/MM/YYYY hh:mm' ),'DD/MM/YYYY hh:mm')

and it ok

thank you Anil