First time here? Check out the FAQ!

getting changes from photos database which timestamp to use?

I don't know if others have run into this issue, and i did not have a problem till now(ignorance is bliss) the photo data base shows multiple timestamps and these seem to be the most relevant L_UpdateDate - _Last_Photo_updt - MED_update_dt. if you look they are all different times.

the L_UpdateDate reflects the change to the listing table. the L_Last_Photo_updt shows the change to the photo and the MED_update_dt is slightly different than the L_Last_Photo_updt.

i found relying on the L_UpdateDate does not get the changes if they happen within an hour or so. i am trying the MED_update_dt to see if that is better, what do you recommend,

bscdata's avatar
asked 2018-08-10 10:24:46 -0500
edit flag offensive 0 remove flag close merge delete


add a comment see more comments

1 Answer


Dates in the Media resource:
L_UpdateDate - Updated whenever listing data is changed. Not really useful for photos.
L_Last_Photo_updt - Updated whenever images are added/updated/deleted/reordered for the listing.
MED_update_dt - Updated whenever that particular media item is updated. A photo label change, for example may not be reflected in the Last_Photo_updt field.

When working with the Media resource, I would suggest that you use the L_Last_Photo_updt as your incremental. Then it would get all the image URLs for that property whenever the photos change.

bwolven's avatar
answered 2018-08-13 10:08:38 -0500
edit flag offensive 0 remove flag delete link


add a comment see more comments

Your Answer

Login/Signup to Answer