欧美精品亚洲精品日韩经典,午夜秒播,国产福利精品一区二区,亚洲国产成人精品久久,亚洲免费专区,国产精品国产三级国产a,日韩福利网站

龍巖易富通網(wǎng)絡(luò )科技有限公司

龍巖小程序開(kāi)發(fā),龍巖分銷(xiāo)系統

mysql的時(shí)間轉換問(wèn)題

2015.09.10 | 678閱讀 | 0條評論 | 數據庫

1、UNIX時(shí)間戳轉換為日期用函數: FROM_UNIXTIME()


select FROM_UNIXTIME(1156219870);


2、日期轉換為UNIX時(shí)間戳用函數: UNIX_TIMESTAMP()


Select UNIX_TIMESTAMP('2006-11-04 12:23:00′);


3、日期時(shí)間格式函數:DATE_FORMAT() 


例:mysql查詢(xún)當天的記錄數:


$sql="select * from message Where DATE_FORMAT(FROM_UNIXTIME(chattime),'%Y-%m-%d') = DATE_FORMAT(NOW(),'%Y-%m-%d') order by id desc";


當然大家也可以選擇在PHP中進(jìn)行轉換UNIX時(shí)間戳轉換為日期用函數: date()


date("Y-m-d H:i:s", 1156219870);


日期轉換為UNIX時(shí)間戳用函數:strtotime()


strtotime("2010-03-24 08:15:42");



實(shí)例:

/*

周五 0點(diǎn)至12點(diǎn) 注冊醫生信息(id,姓名、醫院、科室、職稱(chēng))

*/

select unix_timestamp("2011-09-02 00:00:00"),unix_timestamp("2011-09-02 12:00:00");


select us.uid as "ID",us.username as "用戶(hù)名",usf.workunit as "所在醫院",usf.jobtitle as "職稱(chēng)",usf.kee as "一級科室",usf.keee as "二級科室",usf.keeee as "三級科室" from uchome_space us,uchome_spacefield usf where us.uid=usf.uid   and dateline between unix_timestamp("2011-09-02 00:00:00") and unix_timestamp("2011-09-02 12:00:00") and workunit !="" order by dateline desc;



贊 (

發(fā)表評論