PHP Date for mysql Date

Question

I have a column of type date (only date) in mysql. However, when I am using the following:

$Answer->dateCreated=date('d-m-y');

I'm getting an error

A non well formed numeric value encountered

Any idea??

without seeing your object code its any ones guess

user557846
– user557846

2011-11-17 03:13:03 +00:00
Commented Nov 17, 2011 at 3:13 — user557846
– user557846, Commented Nov 17, 2011 at 3:13

Marc B · Accepted Answer · 2011-11-17 03:16:39Z

3

MySQL's date format is yyyy-mm-dd, which in PHP would be date('Y-m-d'). Your format string is reversed and using 2 digit years instead of 4 - Y2k's old news by now... don't use 2 digit years anymore.

answered Nov 17, 2011 at 3:16

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

Comments

Bart · Accepted Answer · 2011-11-17 14:49:50Z

1

I just did this and it is working:

$Answer->dateCreated = strtotime("now");

edited Nov 17, 2011 at 14:49

Bart

20.1k8 gold badges72 silver badges80 bronze badges

answered Nov 17, 2011 at 3:56

Noor

20.2k41 gold badges147 silver badges264 bronze badges

Comments

Michael Leaney · Accepted Answer · 2011-11-17 03:15:58Z

0

Try:

define('MYSQL_DATE_FORMAT', 'Y-m-d H:i:s');
$Answer->dateCreated = date(MYSQL_DATE_FORMAT);

I understand you're not wishing to save the time, don't worry MySQL will ignore the time for these columns.

answered Nov 17, 2011 at 3:15

Michael Leaney

7514 silver badges10 bronze badges

Comments

abhinav · Accepted Answer · 2011-11-17 03:17:36Z

0

Try using $Answer->dateCreated=date('Y-m-d');

answered Nov 17, 2011 at 3:17

abhinav

3,2172 gold badges24 silver badges26 bronze badges

Collectives™ on Stack Overflow

PHP Date for mysql Date

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