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 0000-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 month,
and the day.
Something's wrong I guess.
Take a look at this section of the manual:
http://www.mysql.com/doc/en/Date_and_time_functions.html
TO_DAYS() and FROM_DAYS() are intended only for dates as of the
beginning of the year 1582.
Help!
Thank you.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
sql, query
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
