Revisions to Store php datetime in mysql database

Improved Formatting, added linebreaks.

Source Link

Try this:

$my_date = date("Y-m-d H:i:s");
INSERT INTO my_table (date_time) VALUES ('$my_date');

UseIn the date-format parameter of the date function, use :
H'H' for 24 hr24hr format
h'h' for 12 hr12hr format

Try this:

$my_date = date("Y-m-d H:i:s");
INSERT INTO my_table (date_time) VALUES ('$my_date');

Use H for 24 hr format h for 12 hr format

Try this:

$my_date = date("Y-m-d H:i:s");
INSERT INTO my_table (date_time) VALUES ('$my_date');

In the date-format parameter of the date function, use :
'H' for 24hr format
'h' for 12hr format

including seconds in date format

Source Link

Madhu Dollu

Try this:

$my_date = date("Y-m-d H:i"i:s");
INSERT INTO my_table (date_time) VALUES ('$my_date');

Use H for 24 hr format h for 12 hr format

Try this:

$my_date = date("Y-m-d H:i");
INSERT INTO my_table (date_time) VALUES ('$my_date')

Try this:

$my_date = date("Y-m-d H:i:s");
INSERT INTO my_table (date_time) VALUES ('$my_date');

Use H for 24 hr format h for 12 hr format

Source Link

answered Dec 2, 2012 at 16:29

CoursesWeb

Try this:

$my_date = date("Y-m-d H:i");
INSERT INTO my_table (date_time) VALUES ('$my_date')

Return to Answer