Query to change all user's timezone?

[Mijae]

I have no idea about queries, so I dont know how to do this. Help me! :P

I want to change all timezones to GMT-4. Thanks.

[Alan @ CIT]

"UPDATE user SET timezoneoffset = -4" should do it. I'd recommend you test it first though by adding a "WHERE userid = <your-user-id>" to make sure it works correctly :)

Thanks,
Alan.

[Christine]

UPDATE user SET timezoneoffset = '-4';

Don't know whay you would want to do that though?