MySQL

Quick tip – how to generate MySQL random date/time in given range?

Posted on:

Just use: SELECT DATE_FORMAT( FROM_UNIXTIME( RAND() * (UNIX_TIMESTAMP(‘2012-11-13 16:00:00’) – UNIX_TIMESTAMP(‘2012-11-13 23:00:00’)) + UNIX_TIMESTAMP(‘2012-11-13 23:00:00’) ), ‘%Y-%m-%d %H:%i:%s’) where first param UNIX_TIMESTAMP(‘2012-11-13 16:00:00’) is start value, second UNIX_TIMESTAMP(‘2012-11-13 23:00:00’) is […]

Mac

Real Ball for free (Mac)

Posted on:

Real Ball (was 6,99USD) This is an original breakout game, which is made in an unusual space style. The game field is full of iron multicolored bricks. Your […]