Insert current date in datetime format mySQL

Question

I m having problems getting the date inserted properly into my database    date   date  m d Y h i s   time       I use this format  and  it echoes out correctly  however  when  I insert  mysql query  INSERT INTO table   dateposted   VALUES    date        it doesn t appear to work successfully  and  the time remains 00 00 00 If you could find the solution that would be great  thanks

User · Answer

NOW   is used to insert the current date and time in the MySQL table  All fields with datatypes DATETIME  DATE  TIME  amp  TIMESTAMP work good with this function   YYYY-MM-DD HH mm SS  Demonstration   Following code shows the usage of NOW    INSERT INTO auto ins  MySQL Function  DateTime  Date  Time  Year  TimeStamp  VALUES     NOW       NOW    NOW    NOW    NOW    NOW

User · Answer

The best way to make it easier and efficient is this   CREATE TABLE table name   field1        time updated timestamp default current timestamp     Now  when you insert a row into table  you can skip this field  time updated  as it will fill with current time as default value

User · Answer

you can use CURRENT TIMESTAMP  mysql function

User · Answer

Try this instead   date   date  Y-m-d H i s

User · Answer

It depends on what datatype you set for your db table  DATETIME  datatype  MYSQL INSERT INTO t1  dateposted  VALUES   NOW        This will insert date and time into the col  Do not use quote around the val  PHP  dt   date  Y-m-d h i s    INSERT INTO t1  dateposted  VALUES     dt       This will insert date into the col using php var  Wrap with quote   DATE  datatype  MYSQL INSERT INTO t1  dateposted  VALUES   NOW        Yes  you use the same NOW   without the quotes     Because your datatype is set to DATE it will insert only the date  PHP  dt   date  Y-m-d    INSERT INTO t1  dateposted  VALUES     dt       This will insert date into the col using php var   TIME  datatype  MYSQL INSERT INTO t1  dateposted  VALUES   NOW        Yes  you use the same NOW   as well      Because your datatype is set to TIME it will insert only the time  PHP  dt   date  h i s    INSERT INTO t1  dateposted  VALUES     dt       This will insert time

User · Answer

use this   date   date  m d Y h i s   time      and then  in MYSQL do  type varchar  then date and time will be successfully inserted

User · Answer

Just use with your timezone              date default timezone set  Asia Kolkata           date date  Y m d h i sa

User · Answer

date   date  Y-m-d H i s    with the type   datetime  worked very good for me as i wanted to print whole date and timestamp     date   date  Y-m-d H i s     stmtc- bindParam 2  date

User · Answer

I believe  you need to change your code little bit like follows alongside with your database filed type    mysql query  INSERT INTO table   dateposted   VALUES   datetime       Hope  will work perfectly

User · Answer

set the type of column named dateposted as DATETIME and run the following query   INSERT INTO table   dateposted   VALUES  CURRENT TIMESTAMP

User · Answer

If you re looking to store the current time just use MYSQL s functions   mysql query  INSERT INTO  table    dateposted   VALUES  now         If you need to use PHP to do it  the format it Y-m-d H i s so try   date   date  Y-m-d H i s    mysql query  INSERT INTO  table    dateposted   VALUES    date

User · Answer

Try this      datepicker2   datepicker  setDate   new Date   lt    value- gt fecha final  gt

User · Answer

lt  php  date  date  Y-m-d     time date  H m     datetime  date  T   time  mysql query INSERT INTO table   dateposted   VALUES   datetime      gt    lt form action  form php  method  get  gt   lt input type  datetime-local  name  date  value   lt  php echo  datetime    gt   gt   lt input type  submit  name  submit  value  submit  gt

User · Answer

datetime  expects the date to be formated like this  YYYY-MM-DD HH MM SS  so format your date like that when you are inserting

User · Answer

If you Pass date from PHP you can use any format using STR TO DATE   mysql function   Let conseder you are inserting date via html form    Tdate         POST  Tdate                 10 04 2016  Tdate    STR TO DATE    Tdate      d  m  Y         mysql query  INSERT INTO  table    dateposted   VALUES    Tdate        The dateposted should be mysql date type   or mysql will adds 00 00 00 in some case You better insert date and time together  into DB so you can do calculation with hours and seconds          Tdate date  Y m d H i s        this to get current date as text    Tdate    STR TO DATE    Tdate      d  m  Y  H  i  s

[php] Insert current date in datetime format mySQL

Examples related to php

Examples related to mysql