Warning date format expects parameter 1 to be DateTime

Question

I am using the following script to pull the calendar info out of the mysql database and display it on the page  I am trying to re format the date from the standard Mysql date format   but when retrieving it from the database am getting the following error    Warning  date format   expects parameter 1 to be DateTime  string given in C  easyphp www twinfocus managecalendar php on line 24  Warning  date format   expects parameter 1 to be DateTime  string given in C  easyphp www twinfocus managecalendar php on line 24  Warning  date format   expects parameter 1 to be DateTime  string given in C  easyphp www twinfocus managecalendar php on line 24  Warning  date format   expects parameter 1 to be DateTime  string given in C  easyphp www twinfocus managecalendar php on line 24   The Database  as you can see the dates are stored correctly     The script     lt  php       sql2    lt  lt  lt SQL         SELECT           FROM  calendar      SQL      if   result2    db- gt query  sql2    die  There was an error running the query       db- gt error              echo   lt table class  admintable  gt   lt thead gt        echo   lt tr gt  lt th gt Client Names lt  th gt  lt th gt Email lt  th gt  lt th gt Tel lt  th gt  lt th gt Wedding Date lt  th gt  lt th gt Date Created lt  th gt  lt th gt Start Time lt  th gt  lt th gt End Time lt  th gt  lt th gt Price lt  th gt  lt th gt Location lt  th gt  lt th gt Other Info lt  th gt  lt th gt Edit lt  th gt  lt th gt Delete lt  th gt  lt  tr gt  lt  thead gt        while  row2    result2- gt fetch assoc           weddingdate    row2  weddingdate         formattedweddingdate   date format  weddingdate   d-m-Y        echo   lt tr gt  lt td gt    row2  name     lt  td gt  lt td gt    row2  email     lt  td gt  lt td gt    row2  tel     lt  td gt  lt td style  min-width 70px   gt    formattedweddingdate   lt  td gt  lt td style  min-width 70px   gt    row2  datecreated     lt  td gt  lt td gt    row2  starttime     lt  td gt  lt td gt    row2  endtime     lt  td gt  lt td gt  amp pound    row2  price     lt  td gt  lt td gt    row2  location     lt  td gt  lt td style  min-width 400px   gt    row2  otherinfo     lt  td gt  lt td gt  lt a href  managecalendar php  amp key    key   amp editwedding    row2  id      gt Edit lt  a gt  lt  td gt  lt td gt  lt a href  calenderdelete php  amp key    key   amp delwedding    row2  id      gt Delete lt  a gt  lt  td gt  lt  tr gt         echo   lt  table gt       gt

User · Accepted Answer

Best way is use DateTime object to convert your date.

$myDateTime = DateTime::createFromFormat('Y-m-d', $weddingdate);
$formattedweddingdate = $myDateTime->format('d-m-Y');

Note: It will support for PHP 5 >= 5.3.0 only.

User · Answer

I ve tried sean662 s 3rd solution and worked with now   function stored in an INSERT sql an then it s value in the date create   function  After that the variable is then passed through the date format   function and you can have the date order that you like

User · Answer

Why don t you try it like this    Weddingdate   new DateTime  row2  weddingdate      formattedweddingdate   date format  Weddingdate   d-m-Y      Or you can also just do it like     Weddingdate   new DateTime  row2  weddingdate     echo  Weddingdate- gt format  d-m-Y

User · Answer

You need to pass DateTime object to this func  See manual  php  string date format   DateTime  object   string  format     You can try using   date format  new DateTime  time    d-m-Y      Or you can also use    date   date create  2000-01-01    echo date format  date   Y-m-d H i s

User · Answer

This may help   formattedweddingdate  date  d-m-Y  strtotime  weddingdate

User · Answer

try this    start date   date create   POST  start date      start date   date format  start date  Y-m-d H i s

[php] Warning: date_format() expects parameter 1 to be DateTime

Examples related to php

Examples related to date