You’re offline. This is a read only version of the page.
Announcements
15
Hi,
I have to store timestamp data using the format yyyy-MM-dd hh:mm:ss.fff in a dataverse table
I did not find any documentation of a dataverse datetime format using milliseconds. I tried to import the data in a datetime column and data were rounded at the second level, for example 2022-11-04 05:16:30.345 rounded to 2022-11-04 05:16:30.
Any idea to store a datetime including milliseconds data except patching value in a text column?
Thanks.
Hello, @PatOnRail, I did some research and testing and it doesn't seem possible without using a Text column. I was thinking of using a Formula column and use the DateAdd function to add 1 milliseconds but the TimeUnit.Milliseconds is not supported and all others: hours, minutes and seconds are supported.
| If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit my Blog: www.powerplatformplace.com
|
Share
Report
All responses (
Answers (
