changing time zone !!

[hassank1]

the date/time  saved in my database depends on the server time zone ..

 

how can I when I fetch the saved Date from my DB to convert it to a different timezone before "echo" it ..

[amites]

couple ways,

 

1 set the timezone (assuming PHP 5) - see http://us3.php.net/manual/en/function.time.php for instructions

 

2: create a function to alter the time before being displayed to sync up with the timezone you want to use,

 

which can be scaled into a user selectable timezone

 

3: adjust the time before putting into your DB, which means not using now() statements but now() + INTERVAL X HOURS

 

or something along those lines

 

hope this helps

[hassank1]

Ok thx .. I'll check them out ..

 

what about the date that's already been saved according to the server time.. is there a SQL query to alter the date fields so the date will increase an X number of hours ?

[amites]

something along the lines of

 

UPDATE table SET field = field + INTERVAL X HOUR

[hassank1]

something along the lines of

 

UPDATE table SET field = field + INTERVAL X HOUR

 

if the date will increment let's say 1 day after adding X hours .. the mysql engine will handle that automatically right ?

[amites]

yup,

 

mySQL is smart