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))
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))