mysql 时间戳

[codeyell-com]

mysql如何取得今天0时的时间戳？
谢谢

[ACMAIN_CHM]

mysql> select curdate();
+------------+
| curdate() |
+------------+
| 2011-01-13 |
+------------+
1 row in set (0.00 sec)

mysql> select UNIX_TIMESTAMP(curdate());
+---------------------------+
| UNIX_TIMESTAMP(curdate()) |
+---------------------------+
| 1294848000 |
+---------------------------+
1 row in set (0.08 sec)

mysql>

[iihero_]

用curdate()即可。

mysql> create table ttt(id timestamp);
Query OK, 0 rows affected (0.16 sec)

mysql> insert into ttt values(now());
Query OK, 1 row affected (0.05 sec)

mysql> select * from ttt;
+---------------------+
| id                  |
+---------------------+
| 2011-01-13 12:45:08 |
+---------------------+
1 row in set (0.00 sec)

mysql> insert into ttt values(curdate());
Query OK, 1 row affected (0.06 sec)

mysql> select * from ttt;
+---------------------+
| id                  |
+---------------------+
| 2011-01-13 12:45:08 |
| 2011-01-13 00:00:00 |
+---------------------+
2 rows in set (0.00 sec)

mysql>

[lxq19851204]

UNIX_TIMESTAMP()  
UNIX_TIMESTAMP(date)  
　返回一个Unix时间戳(从'1970-01-01 
00:00:00'GMT开始的秒数,date默认值为当前时间)
mysql> select UNIX_TIMESTAMP();  
　　-> 882226357  
mysql> select UNIX_TIMESTAMP('1997-10-04 
22:23:00');  
　　-> 875996580  
FROM_UNIXTIME(unix_timestamp)  
　以'YYYY-MM-DD 
HH:MM:SS'或YYYYMMDDHHMMSS格式返回时间戳的值(根据返回值所处上下文是字符串或数字) 
mysql> select 
FROM_UNIXTIME(875996580);  
　　-> '1997-10-04 22:23:00'  
mysql> 
select FROM_UNIXTIME(875996580) + 0;  
　　-> 19971004222300  
FROM_UNIXTIME(unix_timestamp,format)  
　以format字符串格式返回时间戳的值
mysql> 
select FROM_UNIXTIME(UNIX_TIMESTAMP(),'%Y %D %M %h:%i:%s %x');  
　　-> 
'1997 23rd December 03:43:30 x'  

[小小小小周]

mysql> select date_format(now(),'%Y-%m-%d 00:00:00') as ttt;
+---------------------+
| ttt                 |
+---------------------+
| 2011-01-13 00:00:00 |
+---------------------+