Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I change TimeStamp from US server to UK time

843854Oct 12 2003 — edited Oct 24 2003

Hello,

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.

I would like to change the timestamp so that it is GMT.

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.

Thanks

Andrew

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 21 2003

Added on Oct 12 2003

#java-database-connectivity-jdbc

15 comments

570 views