user3150060
user3150060

Reputation: 1745

Set date in database MYSQL php to Zero

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"

Upvotes: 0

Views: 553

Answers (3)

Nagaraj S
Nagaraj S

Reputation: 13484

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

Upvotes: 0

NativeWebs
NativeWebs

Reputation: 63

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.

Upvotes: 1

Nouphal.M
Nouphal.M

Reputation: 6344

You could set the date field to null in sql

UPDATE  tableName SET dateField = NULL WHERE condition

Upvotes: 0

Related Questions