I have a situation, where I need to check if the file in the web server is older than the last published time in the broker. But the problem is the presentation farm and Tridion servers are not in the same time zone.
I found an issue when I tried to update a binary item shortly after it was initially published. If I published at 12pm cms time (PST) and a presentation server grabbed the item, it had a modification time 12pm in the broker but a local modification time in presentation server of 3pm (3 hours time difference as it is in EST). If the same binary item was changed and published an hour later, the time is updated in the broker to 1pm, but the code ignores the new asset since it is earlier than 3pm (the local modification time).
As a solution, currently I am updating the last modified time of the file with the last published time from broker, every time I am updating the file.
But, can we force Tridion to store the UTC time instead of local time in both CMS & broker DB? or is there any better solution available for the above scenario.