<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1601" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Tahoma size=2><SPAN
class=875373708-16102007>Hello,</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=875373708-16102007>
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...</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=875373708-16102007></SPAN></FONT> </DIV>
<DIV><FONT><SPAN class=875373708-16102007><SPAN class=code> delete from
program where starttime < date_sub(curdate(), interval 1 day) or starttime
> date_add(curdate(), interval 14 day);</SPAN></SPAN></FONT></DIV>
<DIV><FONT><SPAN class=875373708-16102007><SPAN
class=code></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=875373708-16102007><SPAN class=code>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.</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=875373708-16102007><SPAN
class=code></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=875373708-16102007><SPAN
class=code>
Many thanks,</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=875373708-16102007><SPAN
class=code> Ian.</SPAN></SPAN></FONT></DIV></BODY></HTML>