mysql调用系统时间_mysql 获取系统时间

mysql> select   now();

+---------------------+

| now()               |

+---------------------+

| 2011-06-11 12:00:54 |

+---------------------+

1 row in set (0.00 sec)

mysql> select   sysdate();

+---------------------+

| sysdate()           |

+---------------------+

|2011-06-11 12:00:54 |

+---------------------+

1 row in set (0.00 sec)

mysql> select   curdate();

+------------+

| curdate()  |

+------------+

| 2011-06-11 |

+------------+

1 row in set (0.00 sec)

mysql>  select   current_date;

+--------------+

| current_date |

+--------------+

| 2011-06-11   |

+--------------+

1 row in set (0.00 sec)

mysql>  select   curtime();

+-----------+

| curtime() |

+-----------+

| 12:00:54  |

+-----------+

1 row in set (0.00 sec)

mysql> select   current_time;

+--------------+

| current_time |

+--------------+

| 12:00:54     |+--------------+

1 row in set (0.00 sec)

2. mysql (unix 时间戳、日期)转换函数：

unix_timestamp(),

unix_timestamp(date),

from_unixtime(unix_timestamp),

from_unixtime(unix_timestamp,format)

下面是示例：

select unix_timestamp(); -- 1218290027 ===得到当前时间的unix时间值

将具体时间来转换成timestamp

select unix_timestamp('2008-08-08'); -- 1218124800

select unix_timestamp('2008-08-08 12:30:00'); -- 1218169800

将timestamp来转换成具体时间

select from_unixtime(1218290027); -- '2008-08-09 21:53:47'

select from_unixtime(1218124800); -- '2008-08-08 00:00:00'

select from_unixtime(1218169800); -- '2008-08-08 12:30:00'

select from_unixtime(1218169800, '%y %d %m %h:%i:%s %x'); -- '2008 8th august 12:30:00 2008'

分享到：

2011-06-11 12:29

浏览 1792

分类:数据库

评论