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 .
Try this:
If(Len(Trim(start_time)) > 0, ConvertToLocalTime(Timestamp(25569 + start_time/86400),'GMT-06:00'), Now())
=ConvertToLocalTime(Alt(yourtimestampvalue,Now()),'GMT-06:00')
yourtimestampvalue in above expression has to be 25569+yourtimestampvalue/86400 instead.
So the whole expression should read in your case:
=ConvertToLocalTime(Alt(25569+start_time/86400,Now()),'GMT-06:00')
one example:
hope this helps
regards
Marco