Thread
:
Random MySQL date
View Single Post
#
2
IP: 112.87.30.158
2015-04-18, 11:09 PM
Kimberling City
初级会员
Join Date: 2012-11-16
Posts: 2
SELECT FROM_UNIXTIME(RAND() * (1419955200 - 1230739200) + 1230739200 ,'%Y-%m-%d %h:%i:%s') AS `the_date`;
select FROM_UNIXTIME(1364176514656/1000,'%Y-%m-%d %h:%i:%s')as date ;
Kimberling City
View Public Profile
Find all posts by Kimberling City