Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
Solved! Go to Solution.
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")
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
= DateTime.ToText(DateTime.FromText("2024-10-17T07:19:28.9700000"), [Format = "MM/dd/yyyy hh:mm:ss tt", Culture = "en-US"])
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")