current date in codeigniter query code example

Example: current date in codeigniter

date('Y-m-d');