About
Hi, I'm Christian Castelli, a 28 years old italian programmer located in Pisa (Italy). Here I post small snippets of code which can be useful in my work.Links
Codepuzzling main siteMy Life Style
while(passion) {
try {
myLife.run();
}catch(LifeExceptions) {
stronger++;
continue;
}
}
Following
If you have extracted with PHP or a SQL function a date (“YYYY-MM-DD”) and you want to change the day with a random day, here is it a series of SELECT for doing it:
SELECT date FROM (
-- generates a number x between 1 and 27
SELECT @rand:=(
SELECT FLOOR(1 + (RAND() * 27))
) as rand,
DATE_ADD('2006-05-01',INTERVAL @rand DAY) as date
) as t; -- give an alias, otherwise it's uncorrect
