Re: Is this a MySQL error?

2002-12-26 Thread Paul DuBois
At 11:47 +0200 12/25/02, Octavian Rasnita wrote: Hi all, I gave the following command in the default MySQL client: select from_days(365); The result is -00-00 instead of 0001-00-00. If I gave the following command: select from_days(366); It gives the result 0001-01-01. If I give numbers

Re: Is this a MySQL error?

2002-12-25 Thread Benjamin Pflugmann
Hello. On Wed 2002-12-25 at 11:47:22 +0200, [EMAIL PROTECTED] wrote: > Hi all, > > I gave the following command in the default MySQL client: > > select from_days(365); > > The result is -00-00 instead of 0001-00-00. > > If I gave the following command: > > select from_days(366); > > It g

Is this a MySQL error?

2002-12-25 Thread Octavian Rasnita
Hi all, I gave the following command in the default MySQL client: select from_days(365); The result is -00-00 instead of 0001-00-00. If I gave the following command: select from_days(366); It gives the result 0001-01-01. If I give numbers less than 356, the result is 0 for the year, the