Mubashshir
  • Home

Random Date

mubashshir
March 16, 2012

Random date, minimum being today max being anything up to 1000 days
[code lang=”sql”]</pre>
UPDATE tablename
SET date = CURDATE() + interval rand()*1000 day
<pre>[/code]

Tags:
  • date
  • mysql
  • random

Related Articles

August 25, 2020

Hello world!

December 23, 2011

Programmer Competency Matrix

December 21, 2011

Well I lost all my posts… but oh well.

Mubashshir

© Mubashshir. 2021 Htmlstream. All rights reserved