how curdate function could return date in mm/dd/yyyy format php

Question

I need to select current date from database in mm/dd/yyyy format..But php curdate() function returns date format in yyyy-mm-dd as default..How could I resolve this issue.?

My model function is:

public function get_cat($category)
    {
        $this->db->select('*');
        if($category!='')
        {
            $this->db->like('Category',$category,'both');
            $this->db->from('tbl_job');
            $this->db->where('Expiry_date >=','DATE(CURDATE())',FALSE);
            $result = $this->db->get();
        }
        return $result->result();
    }

I'm using varchar type in my db. – Hanan Ashraf Nov 30 '15 at 05:28 — Hanan Ashraf, Nov 30 '15 at 05:28

score 2 · Accepted Answer · answered Nov 30 '15 at 05:20

2

Use DATE_FORMAT to format the date

DATE_FORMAT(curdate(), '%m/%d/%Y')

answered Nov 30 '15 at 05:20

Thamilhan

13,040
5
37
59

score 0 · Answer 2 · answered Nov 30 '15 at 05:20

0

use Str_to_date

Str_to_date(Expiry_date,'%m/%d/%Y')

Try this code :-

$this->db->where('Str_to_date(Expiry_date,'%m/%d/%Y') >=','DATE(CURDATE())',FALSE);

answered Nov 30 '15 at 05:20

Abhishek Sharma

6,689
1
14
20

how curdate function could return date in mm/dd/yyyy format php

2 Answers2

Linked