Hi All... I have what I thought would be a simple problem but I can't seem to find an example or pointer anywhere to solve it.
I have a simple CSV file with weather data in it.
It includes a timestamp for the data that is in UTC.
I need to convert that timestamp into local time.
Now I should be able to use sed to grab the correct data out of the file, but how can I do the math to change the date?
Thank you ever so much. Here's the file:
Timestamp,Temp, Chill,HIndex,Hu mid,Dewpt,Wind, HiWind,WindDir, Rain,Barom,Sola r,ET,UV
20071128 06:58:10,0.3,0. 3,0.3,96,-0.2,0,3,19,0.5, 1030.2 +
I have a simple CSV file with weather data in it.
It includes a timestamp for the data that is in UTC.
I need to convert that timestamp into local time.
Now I should be able to use sed to grab the correct data out of the file, but how can I do the math to change the date?
Thank you ever so much. Here's the file:
Timestamp,Temp, Chill,HIndex,Hu mid,Dewpt,Wind, HiWind,WindDir, Rain,Barom,Sola r,ET,UV
20071128 06:58:10,0.3,0. 3,0.3,96,-0.2,0,3,19,0.5, 1030.2 +