Log in

View Full Version : vb3.54 - "Is DST currently in effect" to YES - for all the users via a Query


mrmike
03-30-2008, 06:56 PM
Hi!

Please help me!

Does anyone know how to set "Is DST currently in effect" to YES - for all the users via a Query?

I'm running vb3.54

Solved:

DST ON: UPDATE [tableprefix]user SET options=options + 128 WHERE NOT(options & 128)

DST OFF: UPDATE [tableprefix]user SET options=options - 128 WHERE options & 128