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
#2

Research the php functions to convert a string into datetime.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB