Unanswered: How do I change TimeStamp from Eastern Standard Time to UK GMT time on database
I am based in the UK. My hosting company is based in the US. I am using a MySql database. All the database tables have timestamps that are set to the local machine time. When I insert information the timestamp is automatically allocated to Eastern time
I would like to change the timestamp so that it is a GMT on insert.
Can you please tell me how I would go about doing this?
Is their any code available to enable me to insert the timestamp as a GMT date or do I set the value from the mysql database end.