mysql - Codeigniter:从 DateTime Mysql 获取日期

Question

查询Codeigniter:

$bookvisit = $this->db->query("SELECT 
                            (
                                SELECT 
                                    name 
                                FROM 
                                    tbl_user as u 
                                WHERE 
                                    u.user_id=b.user_id
                            ) as BookVisitFrom,
                                 b.status as status,
                                 b.booktime as booktime,
                                 b.bookdate as bookdate,
                                --> b.created as created,
                                 b.is_confrim as is_confrim,
                                 b.id as id
                            FROM 
                                tbl_bookvisit as b
                           ");

我只想要“创建”(其列名称)中的日期时间中的日期，我怎样才能得到它!!

Answer 1

您可以使用date函数来实现

date(b.created)  as created

mysql> select date('2015-01-01 20:30:40') as only_date ;
+------------+
| only_date  |
+------------+
| 2015-01-01 |
+------------+
1 row in set (0.00 sec)