Codeigniter: Get Date From DateTime Mysql

Question

Query 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
                           ");

I want only Date from DateTime from the "created"(its column name) how can i get it!!

This query working?It should produce error.WHERE u.user_id=b.user_id is invalid statement — Shaiful Islam
– Shaiful Islam, Commented Mar 18, 2015 at 8:14
i am getting all database values but in need DATE only in created column — Pranav Shah
– Pranav Shah, Commented Mar 18, 2015 at 8:39

Abhik Chakraborty · Accepted Answer · 2015-03-18 07:41:57Z

2

You can use date function for it

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)

answered Mar 18, 2015 at 7:41

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Codeigniter: Get Date From DateTime Mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related