Welcome Guest, Not a member yet? Register   Sign In
Get date from datetime fielld
#1

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?
Reply


Messages In This Thread
Get date from datetime fielld - by pippuccio76 - 05-08-2024, 12:03 PM
RE: Get date from datetime fielld - by Bosborne - 05-08-2024, 04:11 PM



Theme © iAndrew 2016 - Forum software by © MyBB