Forum Discussion
Solved
Convert bigint to datetime
Hi there, How can I convert bigint datatype to date/time datatype in Power BI ? Thanks
Hi suvechha ,
If it is timestamp, maybe you could try this as well in Query Editor.
DateTimedValue=#datetime(1970,1,1,0,0,0)+#duration(0,0,0,[timestamp])If it is formated as yyyymmdd, you could try this in Data View:
column = DATE(LEFT('Table 1'[Column1],4),MID('Table 1'[Column1],5,2),RIGHT('Table 1'[Column1],2))
it depends on what your time format is? epoch, excel ??
can you provide an example?
peraphs he is refering to the function
date.from(value)
Yeah Anonymous it is hard to know what exactly is being asked. Date.From converts the standard Excel style date (integer starting at 0 for Dec 31, 1899) to a date. I've never used that. Just changing the type from Int to Date does that. But I could see it being useful if nested in another formula.
