[mythtv-users] Filenames and UTC

[mythtv at phipps-hutton.freeserve.co.uk]

Quoting John Pilkington <J.Pilk at tesco.net>:

> There are clearly many ways of mending this; I looked on the wiki  
> and found things like %PROGSTARTUTC%  for use in setting up a user  
> job, but it isn't clear how I would use it in the cases above.
>
> Can anyone recommend a simple general solution that already exists?  
> bash and/or python wanted.

If you're generating SQL to find things I've had to use

set time_zone = UTC;

to force mysql to not translate times to my time zone.