<div>
Timestamps are expressed in seconds, so,<br />
<br />
UPDATE SMSIN_copy<br />
SET validDate = realdate - (6 * 60 * 60)<br />
where realdate &gt;&nbsp;CURRENT_TIMESTAMP()
</div>


Timestamps are expressed in seconds, so,

UPDATE SMSIN_copy
SET validDate = realdate - (6 * 60 * 60)
where realdate > CURRENT_TIMESTAMP()

<div>
Thanks for the quick response!<br />
<br />
I ran the script but I get an odd output, below is just one of the results<br />
<br />
realdate = 2008-10-21 12:30:43<br />
<br />
but <br />
<br />
validDate = 2008-10-21 10:14:43<br />
<br />
Any ideas??<br />
<br />
Thanks
</div>


Thanks for the quick response!

I ran the script but I get an odd output, below is just one of the results

realdate = 2008-10-21 12:30:43

but

validDate = 2008-10-21 10:14:43

Any ideas??

Thanks

<div>
Brilliant, works perfectly. Cheers.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a need to minus 6 hours from a time stamp if the current timestamp is greater than the current time.<br />
<br />
I have attached the script for you to see.<br />
<br />
Not sure what I'm doing wrong here.<br />
<br />
Any help would be much appreciated.<br />
<br />
Regards<br />
<br />
Ken<br />

<pre><code id="code-175442">UPDATE SMSIN_copy
SET validDate = realdate - 6 hour
where realdate &gt; CURRENT_TIMESTAMP()
</code></pre>
</div>
</div>


Hi,

I have a need to minus 6 hours from a time stamp if the current timestamp is greater than the current time.

I have attached the script for you to see.

Not sure what I'm doing wrong here.

Any help would be much appreciated.

Regards

Ken

How to minus 6 hours from a timestamp?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.