Ask Your Question

datetime field record exists but querying shows no record (DMQL)

asked 2019-07-24 20:16:27 -0600

Actually I have read this post, but no luck :(

I have posted this question on stackoverflow but found this forum instead so I will just post the stackoverflow link here.

edit retag flag offensive close merge delete


Need your RETS login URL and account name (NO PASSWORD) before we can help.

bwolven gravatar imagebwolven ( 2019-07-25 07:05:51 -0600 )edit

Are you still having issues with this?

bwolven gravatar imagebwolven ( 2019-07-25 15:09:52 -0600 )edit

there's a reply on stackoverflow letting me know the encoding is incorrect that's why it's not out putting the + and as for querying with millisecond, documentation doesn't seem to have anything about it as mentioned by the stackoverflow reply. So just want to confirm so if I want to query a record which has exact millisecond saved in db, is not possible then?

et4891 gravatar imageet4891 ( 2019-07-25 16:19:51 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2019-07-25 16:24:18 -0600

RETS specification limits the millisecond to 1 digit so rounding happens.
So it would not be very helpful to do that.
If you need to reference a individual listing, it is best to do it by the unique KeyField value.

edit flag offensive delete link more


ah I get what you mean, so with datetime it's pretty much having + or - would be most use cases especially if I want to query in between date / datetime

et4891 gravatar imageet4891 ( 2019-07-25 16:35:07 -0600 )edit

Yes. Also when doing incremental updates it is best to have some timestamp overlap from the previous request to make sure you don't miss any updates.

bwolven gravatar imagebwolven ( 2019-07-25 16:37:58 -0600 )edit

thanks thanks for the advices :D I guess these are the questions I have for now. ^_^

et4891 gravatar imageet4891 ( 2019-07-25 16:52:25 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-24 20:16:27 -0600

Seen: 404 times

Last updated: Jul 24 '19