how to insert date time object in the type of DateTime column in database using php

Question

I want to insert a DateTime object in database where the column type is DateTime. How can I achieve this?

I am using this code:

 $cdate = new DateTime('now')
     $cd = $cdate->format('d/m/Y h:i:sa')
$udate = new DateTime('72 hours');
     $ud = $udate->format('d/m/Y h:i:sa')
          $insert = "insert into `winpc_user(mac_address,reg_date,updated_date,status,processor_name,ram_size,os_Name, os_Bits) values('$mac','$cdate','$udate','$stat','$proName','$rSize','$osName','$osBits')"

FYI: DATETIME's format is YYYY-MM-DD HH:MM:SS, dev.mysql.com/doc/refman/5.1/en/datetime.html — Kevin
– Kevin, Commented Jan 30, 2015 at 7:29

Kevin · Accepted Answer · 2015-01-30 07:37:54Z

4

Same as the comment above, DATETIME's format is:

YYYY-MM-DD HH:MM:SS

Quite straightforward to follow using date()'s format function, it'll share the same with the ->format():

->format('Y-m-d H:i:s');

Sidenote: Of course, this needs to be quoted as well on insertion.

As an alternative, you could also use MySQL functions to achieve the same goal:

NOW()
DATE_ADD(NOW(), INTERVAL 72 HOUR)

edited Jan 30, 2015 at 7:37

answered Jan 30, 2015 at 7:32

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to insert date time object in the type of DateTime column in database using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related