Hi All,
My application runs in
Java and my Database is Mysql.
The application handles various sports results and scores across the world. My application converts everything to EST and stores in DB and while displaying converts the times to local timezones and shows it.
Till now I have a virtual machine where I set the timezone to EST and both my Java and Database running there.
And all my time calculations in Java used EST as the system zone.
I see the laptop timezone also to EST so that I can run the
test cases and import the database from server for testing.
But now I want to move the infra.. and that new server does not support the EST timezone , both Java and MysQL servers. So I have to change my code to UDT also change the entire database entries to EDT.
I know I am doing something wrong.
So is there a way to write the code and store the data, where I can store the data and deploy the application in any server irrespective the servers timezone setup ?
Lets the I have the data and Java application ..
1. I should be able to deploy the application in IST (India Standard Time) laptop and connect to DB server which is running on UDT.
2. I should be able to dump the data into my laptop (again in IST) and run the application without any issues.
3. I should be able to deploy the application in a server which is running UDT and access the db which is running in UDT server without any issues..
Can someone please help suggesting the best way to handle this..
Regards,
Bala.