[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