[mythtv-users] Guide data until 2038
George Rocklein
grocklein at comcast.net
Tue Oct 16 13:44:32 UTC 2007
Are there any good shows on in 2038?
Ian Hodgson wrote:
> Hello,
> Earlier this year, there was a post asking about a way to solve
> Myth reporting that it had TV guide data until 2038. The solution
> posted was to tidy the database with the following SQL script...
>
> delete from program where starttime < date_sub(curdate(), interval 1
> day) or starttime > date_add(curdate(), interval 14 day);
>
> I also have the '2038 problem' but have no idea of how to execute the
> script supplied to the previous poster. Can anyone help with the full
> sequence of commands so that I can correct the error in my database.
>
> Many thanks,
> Ian.
> ------------------------------------------------------------------------
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
More information about the mythtv-users
mailing list