Converting Epoch Datetime into regular datetime format

[ekodami]

Hi all, I am trying to convert the epoch datettime from my imported record into a more readable datetime. I am using a nativeQuery to my PostGre database. Here is the formula I have been using and the given result. The issue is that I am not get the minutes and seconds but only the date with a default 12:00:00 a.m

"SELECT DATE('1970-01-01') + (c1000000348/ 86400) AS ""Submitted Date"" from txxx".

I have tried this other formula adding a custom column as below

= Table.AddColumn(#"Change Type", "DateTime", each #datetime(1970,1,1,0,0,0) + #duration(0,0,0,[c1000000348]), type DateTime)

: but I am getting an error stating: "Expression.SyntaxError: The type identifier is invalid."

Pls assist

Thank you

[ekodami]

Thank you Nate!

[nathancwatkins · Accepted solution]

It's type datetime, not DateTime.

--Nate