What exactly happens when you change the time client side?
Does it make night look like day, day look like night etc?

I believe it just changes how you see the world's time. For example, if it's night on a server, it'll still display you day on your client. But it still is night for other player etc...