On Mon, 2011-03-21 at 19:50 +1100, James Cameron wrote: > On Mon, Mar 21, 2011 at 08:24:25PM +1300, Tabitha Roder wrote: > > Power logs are attached. This release is in timezone "CST" which broke the > > power log workflow as timezones seem to be very difficult in python. How do > > I > > convert a string with a three letter timezone into seconds since the epoch? > > I > > still haven't shared this script but the relevant code is: > > > > # WTF this doesn't parse 'Sat Mar 19 09:20:45 CST 2011' > > # laptopTZDate = datetime.strptime(dateString[6:-1], "%a %b %d %H:%M:%S > > %Z > > %Y") > > # this only works for input in GMT > > laptopTZDate = time.strptime(dateString[6:-1], "%a %b %d %H:%M:%S %Z > > %Y") > > localTZDate = time.localtime(calendar.timegm(laptopTZDate)) > > The logging script needs a change that has already been applied to > panelpwr-log [1], which records both the UNIX epoch timestamp (%s) and > the "date -R" output, as a result the time would be better formatted for > processing.
Recording the unix epoch timestamp sounds great! I'll look out for that in future builds. > In the meanwhile, set TZ to Australia/Darwin, strip the CST, and try > strptime again. Uggh. More about what I'm trying to do. After collecting the power logs from each XO, I want to work out which correspond to "today". This is surprisingly difficult when the XOs have some semi-random time zone and our testing sessions often span a day boundary in the GMT time zone. So I wrote a script to rename the log files to my local time. I (foolishly ??) chose to do this in python. I'm running on my laptop, not the XO and it's beginning to sound like I should give up and use java where SimpleDateFormat would be my friend. I could maybe make a mapping between the three letter timezone and the longer timezone name and work out how to change timezones within the script before parsing, but surely there has to be a better way? _______________________________________________ Testing mailing list [email protected] http://lists.laptop.org/listinfo/testing
