[mythtv-users] Guide data until 2038

[Ian Hodgson]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20071016/51839fb9/attachment.htm