title: Codeigniter: Get Date From DateTime Mysql
body: <p>Query Codeigniter:</p>
  
  <pre><code>$bookvisit = $this-&gt;db-&gt;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,
                                  --&gt; b.created as created,
                                   b.is_confrim as is_confrim,
                                   b.id as id
                              FROM 
                                  tbl_bookvisit as b
                             ");
  </code></pre>
  
  <p>I want only Date from DateTime from the "created"(its column name) how can i get it!!</p>