amazon web services - Issue in Fetching current timestamp in mysql database column from remote server to local -

i've using mysql installed in aws rds. i've database multiple tables in column in common datatype timestamp.

problem when insert record in 1 of tables, timestamp column inserted automatically current time. , that's predictable. but, time related place remote server exists. when access locally, i'm getting remote server's local time not want.

any suggestions?

you should getting utc timezone unless you've manually changed default timezone rds instance. in either case, should able predict timezone timestamp going in, , convert local timezone on client side.