Hi sikanderv,

Thank you for the information!

Regards.

A little late, but I hope this helps others. I learned this field is actually a C#.NET ticks type. In T-SQL, you can convert this like so:

CAST((CAST(InsertedDateUTC AS BIGINT) - 599266080000000000) / 10000000 / 24 / 60 / 60 AS datetime)

There are people that use complex custom functions for this conversion, if you’re interested in going that route:

https://www.corstianboerman.com/blog/2018-09-21/converting-net-ticks-to-mssql-datetime-and-back

Hello,

The field is designed and used by the application for easy sorting purpose. It is not a type of date time to be converted to human readable date time. You need to use …/properties/detail endpoint to get actual date time data relating to the property.

Regards.