PHP MYSQL Date format outputs zero

Question

This variable gets inserted into my mysql database:

$n_date = date('d-m-Y');

and in the database i always see this:

0000-00-00 00:00:00

What am i doing wrong?

Why not just use NOW() within your SQL?

eggyal
– eggyal

2013-03-14 20:59:27 +00:00
Commented Mar 14, 2013 at 20:59 — eggyal
– eggyal, Commented Mar 14, 2013 at 20:59

John Conde · Accepted Answer · 2013-03-14 20:57:45Z

2

Because your format is wrong. MySQL expects the date to be in YYYY-MM-DD format. So:

$n_date = date('d-m-Y');

should be

$n_date = date('Y-m-d');

Or, for completeness:

$n_date = date('Y-m-d H:i:s');

answered Mar 14, 2013 at 20:57

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

Comments

J.D. Pace · Accepted Answer · 2013-03-14 20:58:07Z

1

You will need to format dates for insert into MySQL as yyyy-mm-dd.

answered Mar 14, 2013 at 20:58

J.D. Pace

6161 gold badge4 silver badges18 bronze badges

Comments

Kermit · Accepted Answer · 2013-03-14 20:59:32Z

1

Your format is incorrect. Why not just INSERT NOW()?

INSERT INTO tbl (dateCol) VALUES (NOW())

answered Mar 14, 2013 at 20:59

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

Comments

Rick Calder · Accepted Answer · 2013-03-14 20:58:26Z

0

$n_date = date('YYYY-mm-dd hh:ii:ss');

Insert that way.

answered Mar 14, 2013 at 20:58

Rick Calder

18.8k3 gold badges27 silver badges41 bronze badges

Collectives™ on Stack Overflow

PHP MYSQL Date format outputs zero

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related