Object of class DateTime could not be converted to string

Question

I have a table with string values in the format of Friday 20th April 2012 in a field called Film Release  I am looping through and i want to convert them in datetime and roll them out into another table  My second table has a column called Films Date  with a format of DATE  I am receiving this error  Object of class DateTime could not be converted to string   dateFromDB    info  Film Release      newDate   DateTime  createFromFormat  l dS F Y   dateFromDB       http php net manual en datetime createfromformat php    Then I insert  newdate into the table through an insert command   Why am I be getting such an error

User · Answer

Date    row  Received date  - gt format  d m Y     then it cast date object from given in database

User · Answer

Try this    Date    row  valdate  - gt format  d m Y       the result will 01 12 2015   NOTE   row  valdate   its a value date in the database

User · Answer

Because  newDate is an object of type DateTime  not a string  The documentation is explicit      Returns new DateTime object formatted according to the specified   format    If you want to convert from a string to DateTime back to string to change the format  call DateTime  format at the end to get a formatted string out of your DateTime    newDate   DateTime  createFromFormat  l dS F Y    dateFromDB    newDate    newDate- gt format  d m Y       for example

User · Answer

If you are using Twig templates for Symfony  you can use the classic   object date attribute format  d m Y     to obtain the desired formatted date

User · Answer

You re trying to insert  newdate into your db  You need to convert it to a string first  Use the DateTime  format method to convert back to a string

User · Answer

Check to make sure there is a film release date  if the date is missing you will not be able to format on a non-object   if   info  Film Release       check if the date exists     dateFromDB    info  Film Release        newDate   DateTime  createFromFormat  l dS F Y    dateFromDB       newDate    newDate- gt format  d m Y       else       newDate    none        or            newDate     info  Film Release      DateTime  createFromFormat  l dS F Y    info  Film Release   - gt format  d m Y     none

User · Answer

Use this    newDate    dateInDB- gt format  Y-m-d

User · Answer

It s kind of offtopic  but i come here from googling the same error   For me this error appeared when i was selecting datetime field from mssql database and than using it later in php-script  like this     SQL  SELECT Created FROM test table     stmt   sqlsrv query  con   SQL   if   stmt     false         die  print r  sqlsrv errors    true        Row   sqlsrv fetch array  stmt SQLSRV FETCH ASSOC      SQL  INSERT INTO another test table  datetime field  VALUES      Row  Created          stmt   sqlsrv query  con   SQL   if   stmt     false         die  print r  sqlsrv errors    true        the INSERT statement was giving error  Object of class DateTime could not be converted to string  I realized that you CAN T just select the datetime from database   SELECT Created FROM test table   BUT you have to use CONVERT for this field   SELECT CONVERT varchar 24  Created  as Created FROM test table

[php] Object of class DateTime could not be converted to string

Examples related to php

Examples related to mysql

Examples related to datetime

Examples related to insert