how social networking sites maintain timing of post exact to the system time

Question

0.00/5 (No votes)

See more:

SQL-server-2000

, +

I wanna know about social networking sites timing maintenance.It's server is at fixed position then how will it get the exact timing at different location or country.

For example:

I have posted something at (9:30 AM) on social networking sites then it shows the exact time(9:30 AM) of post or it shows exact your system time.

please explain the query to show exact timing of system everywhere.Timing will be independent from server location.

Posted 25-May-15 23:27pm

itsathere

Updated 25-May-15 23:30pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2015-05-26T00:27:00

Well...it's isn't independant of the server time. And yet...it is, sort of.

What you do is store all values in the server relative to a specific time zone (which can be the time zone the server normally lives in but that can be a bad idea) - and the best zone to pick is UCT: Universal Coordinated Time[^] which isn't a time zone at all! :laugh:

UTC is referenced to a single geographic line of longitude and is never affected by "summer time" or "winter time", and is the base for all world time zones. If you store your values in UTC, then you can convert them on the fly to the local time for the correct user anywhere in the world - and the local time will take care of plus or minus x hours, summer time, and so forth. So what your user ends up with is the time specific to their current location, regardless of where in the world they log in from.