Set date in database MYSQL php to Zero

Question

How can i set the date in php to : 0000-00-00 00:00:00?

So I can update the database to date equal to "0000-00-00 00:00:00"

NativeWebs · Accepted Answer · 2014-01-30 04:11:12Z

1

While creating database filed, its TYPE should be DATETIME. So when record will be inserted with blank date value, it will be saved 0000-00-00 00:00:00 automatically.

answered Jan 30, 2014 at 4:11

NativeWebs

635 bronze badges

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

Comments

Nouphal.M · Accepted Answer · 2014-01-30 04:09:37Z

0

You could set the date field to null in sql

UPDATE  tableName SET dateField = NULL WHERE condition

answered Jan 30, 2014 at 4:09

Nouphal.M

6,3281 gold badge20 silver badges28 bronze badges

Comments

Nagaraj S · Accepted Answer · 2014-01-30 04:11:51Z

0

Use datetime datatype.By default it will take 0000-00-00 00:00:00

answered Jan 30, 2014 at 4:11

Nagaraj S

13.5k6 gold badges35 silver badges53 bronze badges

Collectives™ on Stack Overflow

Set date in database MYSQL php to Zero

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related