How are handle different time zone data...

[#1]

I came across an situation where we are receiving data from different time zones and I would like to know what are all various options that are available to handle this senior.

Ex:

  

Location	Date_time	hostname	CPU_usage
EST	7/31/2012 7:00	EST01	20
EST	7/31/2012 8:00	EST01	22
CST	7/31/2012 7:00	CST01	20
CST	7/31/2012 8:00	CST01	22
MST	7/31/2012 7:00	MST01	20
MST	7/31/2012 8:00	MST01	22
PST	7/31/2012 7:00	PST01	20
PST	7/31/2012 8:00	PST01	22

[#2]

Any updates..

[rwunderlich]

What to do want to do, calculate the local time?

[#4]

I would like to know how you guys were dealing this kind of situeation.