PHP date format when inserting into datetime in MySQL

Question

What is the correct format to pass to the date   function in PHP if I want to insert the result into a MySQL datetime type column  I ve been trying date  Y-M-D G i s   but that just inserts  quot 0000-00-00 00 00 00 quot  everytime

User · Answer

Format time stamp to MySQL DATETIME column    strftime   Y- m- d  H  M  S   timestamp

User · Answer

A small addendum to accepted answer  If database datetime is stored as UTC  what I always do   you should use gmdate  Y-m-d H i s   instead of date  quot Y-m-d H i s quot    Or  if you prefer to let MySQL handle everything  as some answers suggest  I would  insert MySQL s UTC TIMESTAMP  with the same result  Note  I understood the question referring to current time

User · Answer

This has been driving me mad looking for a simple answer  Finally I made this function that seems to catch all input and give a good SQL string that is correct or at least valid and checkable  If it s 1999-12-31 it s probably wrong but won t throw a bad error in MySQL   function MakeSQLDate  date        if  is null  date               use 1999-12-31 as a valid date or as an alert         return date  Y-m-d   strtotime  1999-12-31                if    t   strtotime  date       false              use 1999-12-31 as a valid date or as an alert         return date  Y-m-d   strtotime  1999-12-31           else           return date  Y-m-d H i s   strtotime  date

User · Answer

date old    23-5-2016 23 15 23      Date for database  date for database   date   Y-m-d H i s  quot   strtotime  date old       Format should be like  Y-m-d H i s  enter code here

User · Answer

Using DateTime class in PHP7   function getMysqlDatetimeFromDate int  day  int  month  int  year   string     dt   new DateTime      dt- gt setDate  year   month   day     dt- gt setTime 0  0  0  0      set time to midnight   return  dt- gt format  Y-m-d H i s

User · Answer

From the comments of php s date   manual page   lt  php  mysqltime   date   Y-m-d H i s    phptime     gt   You had the  Y  correct - that s a full year  but  M  is a three character month  while  m  is a two digit month  Same issue with  D  instead of  d    G  is a 1 or 2 digit hour  where  H  always has a leading 0 when needed

User · Answer

This is a more accurate way to do it  It places decimals behind the seconds giving more precision    now   date  Y-m-d TH i s uP   time       Notice the  uP   More info  https   stackoverflow com a 6153162 8662476

User · Answer

I use this function  PHP 7   function getDateForDatabase string  date   string        timestamp   strtotime  date        date formated   date  Y-m-d H i s    timestamp       return  date formated      Older versions of PHP  PHP  lt  7   function getDateForDatabase  date         timestamp   strtotime  date        date formated   date  Y-m-d H i s    timestamp       return  date formated

User · Answer

Format MySQL datetime with PHP   date       date  Y-m-d H i s   strtotime str replace  -          POST  date

User · Answer

I use the following PHP code to create a variable that I insert into a MySQL DATETIME column    datetime   date create  - gt format  Y-m-d H i s      This will hold the server s current Date and Time

User · Answer

There is no need no use the date   method from PHP if you don t use a timestamp  If dateposted is a datetime column  you can insert the current date like this    db- gt query  INSERT INTO table  dateposted  VALUES  now

User · Answer

The problem is that you re using  M  and  D   which are a textual representations  MySQL is expecting a numeric representation of the format 2010-02-06 19 30 13 Try  date  Y-m-d H i s   which uses the numeric equivalents  edit  switched G to H  though it may not have impact  you probably want to use 24-hour format with leading 0s

User · Answer

Here s an alternative solution  if you have the date in PHP as a timestamp  bypass handling it with PHP and let the DB take care of transforming it by using the FROM UNIXTIME function   mysql gt  insert into a table values FROM UNIXTIME 1231634282    Query OK  1 row affected  0 00 sec   mysql gt  select   from a table    ---------------------    a date                 ---------------------    2009-01-10 18 38 02    ---------------------

[php] PHP date() format when inserting into datetime in MySQL

Examples related to php

Examples related to mysql