UNIX时间戳转换为日期的函数:FROM_UNIXTIME()
示例代码:
```sql
SELECT FROM_UNIXTIME(1156219870);
```
输出结果:2006-08-22 12:11:10
日期转换为UNIX时间戳的函数:UNIX_TIMESTAMP()
示例代码:
```sql
SELECT UNIX_TIMESTAMP('2006-11-04 12:23:00');
```
输出结果:1162614180
示例代码:
```sql
SELECT UNIX_TIMESTAMP(NOW());
```
输出当前时间戳
MySQL查询当天记录数的示例代码:
```sql
$sql = "SELECT * FROM message WHERE DATE_FORMAT(FROM_UNIXTIME(chattime), '%Y-%m-%d') = DATE_FORMAT(NOW(), '%Y-%m-%d') ORDER BY id DESC";
```
PHP方式转换的示例代码:
UNIX时间戳转换为日期的函数:date()
示例代码:
```php
strtotime('2010-03-24 08:15:42');
```