Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how can convert 23142 into day and time
That might depend on the result you would expect.
Not sure you can covert this to any time as there is no decimal part of the number present here but you can try timestamp() function .. It will change it to a date with timestamp as 00:00:00.. anyways what is the output you want to see?
As Pradosh's response you can use timestamp function for that. But your output with this integer number will look like this:
I have used online tool to convert this number into HH:MM:SS
then I got 06:25:42
How I can calculate in qlikview
format : DD:HH:MM:SS
I would use this
=Interval(23142/86400,'DD:hh:mm:ss')
replace your field with 23142
I have used following expression to calculate Days and Time from given DATENUMBER 23142
=Date(23142,'DD-MM-YYYY HH:MM:SS TT') convert into Date
=day(Date(23142,'DD-MM-YYYY HH:MM:SS TT')) To find Day
=Time#(date(23142,' HH:MM:SS TT')) to find Time
Following attachments shows expected result
Regards,
Sahadev Patil
Thanks all of you
I got the database provides to different values in different conditions
@@Pradosh - I have already applied interval function but due to different values in database I can't map.
I got the solution what I want
Thanks.
Sound's good Rakesh. By the way, if your problem is already solved, please, close the thread.
Cheers
what is your solution?