Forum Discussion
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.
"2024-10-17T07:19:28.9700000" to "17/10/2024 07:19:28 AM"
Thank you.
Regards,
Tan LC
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")
3 Replies
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")
= DateTime.ToText(DateTime.FromText("2024-10-17T07:19:28.9700000"), [Format = "MM/dd/yyyy hh:mm:ss tt", Culture = "en-US"])
Hi TanLC ,
Did you find a solution? Did the answers help? If so, mark the reply as a solution, which will help the next user with a similar problem, thank you~!
Best Regards,
Gao
Community Support Team
