First time here? Check out the FAQ!

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

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.

et4891's avatar
asked 2019-07-24 20:16:27 -0500
edit flag offensive 0 remove flag close merge delete


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

bwolven's avatar bwolven (2019-07-25 07:05:51 -0500) edit

Are you still having issues with this?

bwolven's avatar bwolven (2019-07-25 15:09:52 -0500) 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's avatar et4891 (2019-07-25 16:19:51 -0500) edit
add a comment see more comments

1 Answer


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.

bwolven's avatar
answered 2019-07-25 16:24:18 -0500
edit flag offensive 0 remove flag delete link


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's avatar et4891 (2019-07-25 16:35:07 -0500) 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's avatar bwolven (2019-07-25 16:37:58 -0500) edit

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

et4891's avatar et4891 (2019-07-25 16:52:25 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer