time - MySQL TimeStamp +5 Hours -

i have timestamp column in mysql table. storing timestamps according utc/gmt. wish store in ist format +5 hours utc/gmt.

what query that?

you can use date_add in select/where statement (up needs)... think that's want.

date_add(date_column_name, interval 5 hour)