Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am fetching data from db and storing the data in qvd . in this i am getting values of a date time field as number such as
1426807749 but when i am trying to convert this into time stamp .i am not getting the desired result when i am trying as below
MakeDate(Year(start_time),Month(start_time),Day(start_time)) as Outage_StartTime,
timestamp(start_time) as start_time,
Please suggest how can we convert this into timestamp .
what date 1426807749 this correspond to?
Your excel file data doesn't come from dates.
What's the database are using?
See if this helps:
Yes thats a date time field
its value should be 2015-03-19 17:29:09 . but when i am getting it in qvd its getting changed in number
Hi,
try with
Timestamp(25569 + EpochTimeField / 86400)
so in your case 1426807749 would result in a timestamp 03/19/2015 23:29:09
Re: UNIX DATE to Qlikview DATE
hope this helps
regards
Marco
Yes you are right Marco date is fine now but i can see the value as 03/19/2015 11:29:09 PM
the date is fine but when i see in time for same field in the earlier data which i was getting it 5:29:09 PM .. is there anything which is missing here
maybe localization:
=ConvertToLocalTime(Timestamp(25569 + 1426807749 / 86400),'GMT-06:00')
results in 03/19/2015 5:29:09 PM
Does this match your time zone?
regards
Marco
Thanks .. some of the date value is null which is getting converted 01/01/1970 12:00:00 AM but i want to convert that value to now() i.e. current time