 | |
Toad for mysql v4.6 and datetime 0000-00-00 auto convert
comp.databases comp.databases
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Toad for mysql v4.6 and datetime 0000-00-00 auto convert -
03-02-2010
, 05:20 AM
#2
| |||
| |||
|
|
Toad for mysql auto converts my datetime field value 0000-00-00 to 1.1.0001, when editing any column in row. How to disable that, I want to have 0000-00-00 value in my mysql database? Why do you want to have non-existing ("illegal") dates in the database? |
#3
| |||
| |||
|
|
Why do you want to have non-existing ("illegal") dates in the database? ------------------------------------- |
This is date that Joomla inserts in many tables by default, and it doesn't
work if date in database is 01.01.0001
#4
| |||
| |||
|
|
Why do you want to have non-existing ("illegal") dates in the database? ------------------------------------- This is date that Joomla inserts in many tables by default, and it doesn't work if date in database is 01.01.0001 Wow. Two pieces of software that don't care for correct data... |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.