Converting string to Date and DateTime

Question

If I have a PHP string in the format of mm-dd-YYYY  for example  10-16-2003   how do I properly convert that to a Date and then a DateTime in the format of YYYY-mm-dd  The only reason I ask for both Date and DateTime is because I need one in one spot  and the other in a different spot

User · Answer

You need to be careful with m d Y and m-d-Y formats  PHP considers   to mean m d Y and - to mean d-m-Y  I would explicitly describe the input format in this case    ymd   DateTime  createFromFormat  m-d-Y    10-16-2003  - gt format  Y-m-d      That way you are not at the whims of a certain interpretation

User · Answer

If you wish to accept dates using American ordering  month  date  year  for European style formats  using dash or period as day  month  year  while still accepting other formats  you can extend the DateTime class          Quietly convert European format to American format       Accepts m-d-Y  m-d-y  m d Y  m d y  Y-m-d  Y m d    as well as all other built-in formats         class CustomDateTime extends DateTime      public function   construct string  time  now   DateTimeZone  timezone   null              convert m-d-y or m d y to m d y to avoid PHP parsing as d-m-Y  substr avoids microtime error       time   str replace   -             substr  time  0  10     substr  time  10         parent    construct  time   timezone             usage   date   new CustomDateTime  7-24-2019    print  date- gt format  Y-m-d          gt   2019-07-24    Or  you can make a function to accept m-d-Y and output Y-m-d          Accept dates in various m  d  y formats and return as Y-m-d        Changes PHP s default behaviour for dates with dashes or dots     Accepts       m-d-y  m-d-Y  Y-m-d       m d y  m d Y  Y m d       m d y  m d Y  Y m d           and all other formats natively supported         Unsupported formats or invalid dates will generate an Exception         see https   www php net manual en datetime formats date php PHP formats supported     param  string  d various representations of date     return string    Y-m-d or  ----  for null or blank     function asYmd  d      if is null  d      d        return  ----           convert m-d-y or m d y to m d y to avoid PHP parsing as d-m-Y    d   str replace   -              d      return  new DateTime  d  - gt format  Y-m-d          usage    lt    asYmd  7-24-2019     gt      or   lt  php echo asYmd  7-24-2019      gt

User · Answer

Like we have date  07 May 2018  and we need date  2018-05-07  as mysql compatible     if   empty  date          timestamp   strtotime  date       if   timestamp     FALSE              timestamp   strtotime str replace       -    date                     date   date  Y-m-d    timestamp         It works for me  enjoy

User · Answer

If you have format dd-mm-yyyy then in PHP it won t work as expected  In PHP document they have below guideline       Dates in the m d y or d-m-y formats are disambiguated by looking at   the separator between the various components  if the separator is a   slash      then the American m d y is assumed  whereas if the   separator is a dash  -  or a dot      then the European d-m-y format   is assumed    So  you just can t use as you wish  When your try to use dd mm yyyy format with this then it will remove FALSE  You can tweak with the following    date    23 02 2013    timestamp   strtotime  date   if   timestamp     FALSE       timestamp   strtotime str replace       -    date      echo  timestamp     prints 1361577600

User · Answer

For first Date    firstDate   date  m-d-Y   strtotime   yourDateString      For New Date    newDate   date  Y-m-d  strtotime   yourDateString

User · Answer

Use strtotime   on your first date then date  Y-m-d   to convert it back    time   strtotime  10 16 2003      newformat   date  Y-m-d   time    echo  newformat     2003-10-16   Make note that there is a difference between using forward slash   and hyphen - in the strtotime   function  To quote from php net      Dates in the m d y or d-m-y formats   are disambiguated by looking at the   separator between the various   components  if the separator is a   slash      then the American m d y is   assumed  whereas if the separator is a   dash  -  or a dot      then the   European d-m-y format is assumed       To avoid potential ambiguity  it s best to use ISO 8601  YYYY-MM-DD  dates or DateTime  createFromFormat   when possible

User · Answer

to create date from any string use    date   DateTime  createFromFormat  d-m-y H i    01-01-01 01 00      echo  date- format  Y-m-d H i

User · Answer

If you want to get the last day of the current month you can do it with the following code   last day this month    date  F jS Y   strtotime date  F t Y

User · Answer

d   new DateTime  10-16-2003      timestamp    d- gt getTimestamp       Unix timestamp  formatted date    d- gt format  Y-m-d       2003-10-16   Edit  you can also pass a DateTimeZone to DateTime   constructor to ensure the creation of the date for the desired time zone  not the server default one

User · Answer

To parse the date  you should use      DateTime  createFromFormat     Ex    dateDE    16 10 2013    dateUS    DateTime  createFromFormat  d m Y    dateDE - gt format  m d Y      However  careful  because this will crash with   PHP Fatal error  Call to a member function format   on a non-object    You actually need to check that the formatting went fine  first    dateDE    16 10 2013    dateObj    DateTime  createFromFormat  d m Y    dateDE   if    dateObj        throw new  UnexpectedValueException  Could not parse the date   date       dateUS    dateObj- gt format  m d Y      Now instead of crashing  you will get an exception  which you can catch  propagate  etc    dateDE has the wrong format  it should be  16 10 2013

User · Answer

Since no one mentioned this  here s another way   date   date create from format  quot m-d-Y quot    quot 10-16-2003 quot  - gt format  quot Y-m-d quot

[php] Converting string to Date and DateTime

Examples related to php

Examples related to string

Examples related to datetime

Examples related to date