Forum Discussion
Solved
Convert UTC MilliSeconds DateTime to DateTime format only
Hi, in my file, there's a DateTime column with UTC MilliSeconds & I would like to convert it into DateTime format only without the UTC MilliSeconds either using SQL or Power Query. Please help. ...
Hi TanLC
use the below formula
= DateTime.ToText(DateTime.FromText(Text.Start("2024-10-17T07:19:28.9700000", 23)),"dd/MM/yyyy hh:mm:ss tt")
ZhangKun
Super User
Super User= DateTime.ToText(DateTime.FromText("2024-10-17T07:19:28.9700000"), [Format = "MM/dd/yyyy hh:mm:ss tt", Culture = "en-US"])