Realty in CA

フリーミアム
よって Api Dojo | 更新済み 5 days ago | Business
人気

9.6 / 10

レイテンシー

1,701ms

サービスレベル

100%

Health Check

N/A

すべてのディスカッションに戻る

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.

ディスカッションに参加しましょう-以下にコメントを追加してください:

ログイン/サインアップして新しいコメントを投稿