Reputation: 1745
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
Reputation: 13484
Use datetime
datatype.By default it will take 0000-00-00 00:00:00
Upvotes: 0
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
Reputation: 6344
You could set the date field to null in sql
UPDATE tableName SET dateField = NULL WHERE condition
Upvotes: 0