1ãå°æ¶é´è½¬æ¢ä¸ºæ¶é´æ³
[sql] view plaincopyprint?
select unix_timestamp('2009-10-26 10-06-07')
å¦æåæ°ä¸ºç©ºï¼åå¤ç为å½åæ¶é´
2ãå°æ¶é´æ³è½¬æ¢ä¸ºæ¶é´
[sql] view plaincopyprint?
select from_unixtime(1256540102)
æäºåºç¨çæçæ¶é´æ³æ¯æ¯è¿ä¸ªå¤åºä¸ä½ï¼æ¯æ¯«ç§è¡¨ç¤ºï¼å¦æè¦è½¬æ¢ï¼éè¦å
å°æåä¸ä½å»æï¼å¦åè¿åNULL
UNIX_TIMESTAMP(date)
å¦æ没æåæ°è°ç¨ï¼è¿åä¸ä¸ªUnixæ¶é´æ³è®°(ä»'1970-01-01 00:00:00'GMTå¼å§çç§æ°)ãå¦æUNIX_TIMESTAMP()ç¨ä¸ä¸ªdateåæ°è¢«è°ç¨ï¼å®è¿åä»'1970-01-01 00:00:00' GMTå¼å§çç§æ°å¼ãdateå¯ä»¥æ¯ä¸ä¸ªDATEå符串ãä¸ä¸ªDATETIMEå符串ãä¸ä¸ªTIMESTAMPæ以YYMMDDæYYYYMMDDæ ¼å¼ç æ¬å°æ¶é´çä¸ä¸ªæ°åã
[sql] view plaincopyprint?
mysql> select UNIX_TIMESTAMP();
-> 882226357
mysql> select UNIX_TIMESTAMP('1997-10-04 22:23:00');
-> 875996580
å½UNIX_TIMESTAMP被ç¨äºä¸ä¸ªTIMESTAMPåï¼å½æ°å°ç´æ¥æ¥åå¼ï¼æ²¡æéå«çâstring-to-unix-timestampâåæ¢ã
FROM_UNIXTIME(unix_timestamp)
以'YYYY-MM-DD HH:MM:SS'æYYYYMMDDHHMMSSæ ¼å¼è¿åunix_timestampåæ°æ表示çå¼ï¼åå³äºå½æ°æ¯å¨ä¸ä¸ªå符串è¿æ¯ææ°åä¸ä¸æä¸è¢«ä½¿ç¨ã
[sql] view plaincopyprint?
mysql> select FROM_UNIXTIME(875996580);
-> '1997-10-04 22:23:00'
mysql> select FROM_UNIXTIME(875996580) + 0;
-> 19971004222300
FROM_UNIXTIME(unix_timestamp,format)
è¿å表示 Unix æ¶é´æ è®°çä¸ä¸ªå符串ï¼æ ¹æ®formatåç¬¦ä¸²æ ¼å¼åãformatå¯ä»¥å
å«ä¸DATE_FORMAT()å½æ°ååºçæ¡ç®åæ ·ç修饰符ã
[sql] view plaincopyprint?
mysql> select FROM_UNIXTIME(UNIX_TIMESTAMP(),
'%Y %D %M %h:%i:%s %x');
-> '1997 23rd December 03:43:30 x'
éè¿ UNIX_TIMESTAMP å½æ°æ MySQL æ°æ®åºä¸ç date ç±»åæ°æ®è½¬æ¢æ unix timestamp å½¢å¼çä¸ä¸ªæ´å½¢æ°åï¼
[sql] view plaincopyprint?
select UNIX_TIMESTAMP('2006-02-28') testdate;
[sql] view plaincopyprint?
æç说å¾å°çæ¶é´æ³åºè¯¥å¯ä»¥ç´æ¥æ¿æ¥ç» PHP ç date() çå½æ°ä½¿ç¨ãä½å¥æªçæ¯ï¼
echo date("Y-m-d",$testdate);
æ¾ç¤ºåºæ¥çæ¥æè·æ°æ®åºå®é
çæ¥æç¸æ¯å´å°äºä¸å¤©ï¼ç¾æä¸å¾å
¶è§£ãåå¤æ¥ç MySQL å
³äº UNIX_TIMESTAMP å½æ°ç说æï¼ç»äºåç°é®é¢æå¨ï¼âThe server interprets date as a value in the current time zone and converts it to an internal value in UTC.â åæ¥ MySQL ç UNIX_TIMESTAMP å½æ°å¾å°çæ¶é´æ³æ¯ UTC æ¶é´ï¼èä¸æ¯æå¡å¨è®¾å®çç¹å® Time zone çæ¶é´ãç»è¿è¿æ ·ä¸è½¬åï¼æ¶é´æ³å°±å空å°äº8个å°æ¶ï¼å¯¹äºå±è¿éæ¥è¯´ï¼ï¼è PHP ä¸ç timestamp å计ç®çé½æ¯ç³»ç»è®¾å®æ¶åºçå½å°æ¶é´ãå æ¤ 2006-02-28 è¿ä¸ªæ¥æ被åå»äº8个å°æ¶ï¼èªç¶åæäº2006-02-27ã
[sql] view plaincopyprint?
解å³æ¹æ³ï¼æè¿å
«ä¸ªå°æ¶å åå»ï¼UNIX_TIMESTAMP('2006-02-28' + INTERVAL 8 HOUR)ï¼ï¼æè
å¼ç¨ UNIX_TIMESTAMP å½æ°ï¼ ç´æ¥å¾å° MySQL date å符串ä¹åéè¿ strtotime() å½æ°æ¥æå符串转åæçæ£çæ¬å°æ¶é´æ³ã
æ¾åºä¸ä¸ªæçæ¥çå¨ç©ä¹æ¯å®¹æçãåå®å½åææ¯4æï¼é£ä¹æå¼æ¯4ï¼ä½ å¯ä»¥æ¾å¨5æåºççå¨ç© (5æ)ï¼æ¹æ³æ¯ï¼
[sql] view plaincopyprint?
mysql> SELECT name, birth FROM pet WHERE MONTH(birth) = 5;
.................
$conn=mysql_connect("localhost","root","1234")or die("è¿æ¥æ°æ®åºå¤±è´¥");
$conndb=mysql_select_db("test",$conn)or die("è¿æ¥è¡¨å¤±è´¥");
$query="select * from ttable";
$result = mysql_query($query,$conn);
while($row = mysql_fetch_array($result)){
$rows[]=$row;
}
$random =rand(0,count($rows));
print_r($rows[$random]);
温馨提示:答案为网友推荐,仅供参考