Get date from datetime fielld - Printable Version

Get date from datetime fielld - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: Get date from datetime fielld (/showthread.php?tid=90818)

Get date from datetime fielld - pippuccio76 - 05-08-2024

hi ,
i want search events for a date selected (YYYY-MM-DD) this is my query , in db's table i have datetime field:

Code:
     $lista_eventi_utente = $event_model ->where(SUBSTRING('start', 0, 5),$date)

                                         ->where('id_users',auth()->user()->id)

                                        ->findall();

but have error in SUBSTRING , how can i get date from datetime?

RE: Get date from datetime fielld - Bosborne - 05-08-2024

Research the php functions to convert a string into datetime.