mysql - Times out by 1 hour in database -

i've taken on development of new system previous developer, , honest it's mess.

all diary items ahead 1 hour, format saved in 1355385600. fields responsible time start_time , end_time.

i need way bulk update of entries in database , remove hour them.

do guys have ideas on how can achieve this?

cheers

note: should have mentioned default timezone set correctly 'europe/london' , when add new diary entry times correct. need though, find way bulk update current entries in database go 1 hour. possible?

you need set timezone.

for sites, set timezone date_default_timezone_set('europe/berlin'), , when insert datetime in database, use date('y/m/d h:i:s').

for yours, instead of date('y/m/d h:i:s'), should strtotime(date('y/m/d h:i:s'))