Hello All,
When we search for listings that were updated after a certain timestamp we're seeing listings from the past.
Another screenshot
And when we search for listings exactly on the 30 seconds mark we may occasionally see nothing even though we know listings exist.
Currently the L_UpdateDate field is stored as a smalldatetime which only has an accuracy of one minute.
Thanks for the info. Is there any reasoning why the issue demonstrated in the second screenshot would return nothing?
Is it conceivable that the business would consider making the necessary modifications to return listings that fall within date-range requested in the query? Thanks again for help.
Seconds get rounded to the nearest minute. So once you hit 30 seconds it rounds up to the nearest minute, Less than 30 rounds down. Also be aware times are in UTC (GMT) in Paragon RETS.
Comments