3 ms·
>the time of publication is the only value that makes sense. Which time of publication? The time on the database server? the web server? The client's comput
by mrgoldenbrown 14y ago
>the time of publication is the only value that makes sense.
Which time of publication? The time on the database server? the web server? The client's computer? What time zone? There is probably only one choice that makes sense to you, but I have spent too many hours dealing with bugs resulting from different people having different ideas on which one is the best one.
- wyuenho 14y agoThere is only 1 time acceptable - the ISO-8601 or equivalent time of publication in UTC, under the highest resolution you can get. Format to whatever you need on display. Give an option to the user to adjust the timezone in which the user agrees with, by default the user's timezone, if you know it a priori. All your servers should use the same time server to sync time.