How to insert TIMESTAMP into my MySQL table

Question

In the MySQL table I have a field called date its type is called timestamp and the default is CURRENT TIMESTAMP  However  if I leave the field blank in MySQL I get an error  When I try to insert something into it like time   I receive the date as 0000-00-00 00 00 00   lt  php       name            quot  quot        email           quot  quot        subject         quot  quot        comments        quot  quot        nameError       quot  quot        emailError      quot  quot        subjectError    quot  quot        x              5      function filterData  data                 data   htmlspecialchars  data            data   stripslashes  data           return  data             connection   mysql connect  host    user    pass        if    connection            die  Could not connect      mysql error                          select database   mysql select db  quot contact quot             if    select database            echo  quot could not select database  quot    mysql error                       if    SERVER  quot REQUEST METHOD quot       quot POST quot               handles the name           name   filterData   POST  quot name quot             if  empty  name                  nameError    quot please don t leave the name field blank quot                       handles the email          email   filterData   POST  quot email quot             if  empty  email                  emailError    quot please don t leave the email field blank quot                                handles the subject          subject   filterData   POST  quot subject quot             if  empty  subject                  subjectError    quot please don t leave this field blank quot                               comments   filterData   POST  quot comments quot                              insertation    quot INSERT INTO contactinfo  name  email  subject  date  comments          VALUES    name     email     subject         comments   quot             insertationQuery   mysql query  insertation   connection            if    insertationQuery            echo  quot Could not process your information  quot    mysql error          else           echo  quot Thank you for submitting the information quot                gt

User · Answer

The DEFAULT value of a column in MySql is used only if it isn t provided a value for that column  So if you   INSERT INTO contactinfo  name  email  subject  date  comments  VALUES    name     email     subject         comments     You are not using the DEFAULT value for the column date  but you are providing an empty string  so you get an error  because you can t store an empty string in a DATETIME column  The same thing apply if you use NULL  because again NULL is a value  However  if you remove the column from the list of the column you are inserting  MySql will use the DEFAULT value specified for that column  or the data type default one

User · Answer

You can try wiht TIMESTAMP curdate    curtime    for use the current time

User · Answer

insertation    INSERT INTO contactinfo  name  email  subject  date  comments  VALUES    name     email     subject   CURRENT TIMESTAMP      comments       You can use this Query  CURRENT TIMESTAMP  Remember to use the parenthesis CURRENT TIMESTAMP

User · Answer

If you have a specific integer timestamp to insert update  you can use PHP date   function with your timestamp as second arg   date  quot Y-m-d H i s quot    myTimestamp

User · Answer

In addition to checking your table setup to confirm that the field is set to NOT NULL with a default of CURRENT TIMESTAMP  you can insert date time values from PHP by writing them in a string format compatible with MySQL     timestamp   date  Y-m-d H i s      This will give you the current date and time in a string format that you can insert into MySQL

User · Answer

Please try CURRENT TIME   or now   functions   INSERT INTO contactinfo  name  email  subject  date  comments  VALUES    name     email     subject   NOW      comments      OR   INSERT INTO contactinfo  name  email  subject  date  comments  VALUES    name     email     subject   CURRENT TIME      comments      OR you could try with PHP date function here    date   date  Y-m-d H i s

User · Answer

You do not need to insert the current timestamp manually as MySQL provides this facility to store it automatically  When the MySQL table is created  simply do this    select TIMESTAMP as your column type  set the Default value to CURRENT TIMESTAMP then just insert any rows into the table without inserting any values for the time column   You ll see the current timestamp is automatically inserted when you insert a row  Please see the attached picture

[php] How to insert TIMESTAMP into my MySQL table?

Examples related to php

Examples related to mysql