First time here? Check out the FAQ!

30 second offset in update timestamp?

Hello All,

When we search for listings that were updated after a certain timestamp we're seeing listings from the past.

image description

Another screenshot

image description

And when we search for listings exactly on the 30 seconds mark we may occasionally see nothing even though we know listings exist.

image description

bdavis's avatar
asked 2016-05-16 17:54:11 -0500
edit flag offensive 0 remove flag close merge delete


add a comment see more comments

1 Answer


Currently the L_UpdateDate field is stored as a smalldatetime which only has an accuracy of one minute.

bwolven's avatar
answered 2016-05-17 16:48:19 -0500
edit flag offensive 0 remove flag delete link


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.

bdavis's avatar bdavis (2016-05-17 19:38:44 -0500) edit

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.

bwolven's avatar bwolven (2016-05-18 08:53:13 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer