Realty in CA

FREEMIUM
Door Api Dojo | Bijgewerkt 4 days ago | Business
Populariteit

9.6 / 10

Latency

1,701ms

Serviceniveau

100%

Health Check

N/A

Terug naar alle discussies

InsertedDateUTC

Rapid account: Akarman
akarman
2 years ago

Hi There,
Can you please advise the possible way to convert the InsertedDateUTC into a data / time format? Than you

Best Regards,
Andras

Rapid account: Apidojo
apidojo Commented a year ago

Hi sikanderv,

Thank you for the information!

Regards.

Rapid account: Sikanderv
sikanderv Commented a year ago

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

Rapid account: Apidojo
apidojo Commented 2 years ago

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.

Doe mee aan de discussie - voeg hieronder een opmerking toe

Log in / Schrij u in om nieuwe opmerkingen te plaatsen