Cannot find where a default is set for a date

[piccirm]

Hi

I'm trying to understand why if a create a new task without set any date_due then a date as 1/1/2000 is saved
In the vardefs and editview I do not see any default value set
Where else 'd I look for ?

[kuske]

It's not sugar it's salt....

mySQL tries to interpret a given date value 0 as:
00-00-00 00:00:00

Day 00 must be wrong, so use 1.
Month 00 must be wrong so use 1.
Year 00 must be 2000 as in 1900 there were no databases.
And 00:00:00 is midnight.

So you will get 2000-01-01 00:00:00...