Ask Your Question

30 second offset in update timestamp?

asked 2016-05-16 17:54:11 -0600

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

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2016-05-17 16:48:19 -0600

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

edit flag offensive delete link more


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 gravatar imagebdavis ( 2016-05-17 19:38:44 -0600 )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 gravatar imagebwolven ( 2016-05-18 08:53:13 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-16 17:54:11 -0600

Seen: 582 times

Last updated: May 17 '16