(SLES 10, report generated by extract function & reparsed using bash script)

I have a report in which I have to take the date/time value and change those values to time adjusted to the timezones appropriate to each device (found in last field).

example:

2010-11-05 23:22:48.000000, 0, 0316, 36, 392, 0.00, 0, 0, 0.00, 0.00, 0, 0, UT01

where field 1 is in MST and I want it printed in CST value (which would be "2010-11-06 03:22:48.000000" if I can ever figure this out...).

Is there a built in bash or GNU awk function to take field $1 and convert it to a different timezone value such as CST, EST and PST? I appreciate your input. Thanks in advance.

Check out the man page for the "date" command.

Regards,

Fordeck

Mmmkay, answered my own question. The date function works:

tempdate=`awk {print $1} myreport`
date -d "%tempdate 1 hour ago" +Y-%m-%d\ %H:%m:%S

to set PST dates,

and
date -d "%tempdate 1 hour" +Y-%m-%d\ %H:%m:%S
date -d "%tempdate 2 hours" +Y-%m-%d\ %H:%m:%S

to set CST and EST dates.

I'll likely set up a "for in do done" statement and embed a "case in $timezone" statement beneath that to adjust everything that needs it and avoid adjusting anything that doesn't.

To get time relative to a Time Zone you could 'env TZ=$TZ /bin/date' where TZ is one of PST, CST, etc, you get the point.