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.
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.