MySQL Bugs: #11736: FROM_DAYS(),TO_DAYS(),What date is exactly the advent of the Gregorian Calender

Bug #11736	FROM_DAYS(),TO_DAYS(),What date is exactly the advent of the Gregorian Calender
Submitted:	5 Jul 2005 8:46	Modified:	17 Jul 2005 19:41
Reporter:	Roland Bouman	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:	5.0.7	OS:	NA
Assigned to:	Sergei Golubchik	CPU Architecture:	Any

Description:
The documentation on FROM_DAYS and TO_DAYS function (manual 12.5) states that these functions should not be used with dates "preceding the advent of the Gregorian Calendar (1582)".

What datetime exactly is that thing, the advent? How should we read precede? Is it the exact moment of the advent starts, or is it up to the moment the advent ends?

How to repeat:
NA

Suggested fix:
Please the the first valid date for usage with FROM_DAYS and TO_DAYS in exact terms (YYYY-MM-DD HH24:MI:SS ....).

Sorry my suggested fix should read: Please document the first valid datetime to use for FROM_DAYS() and TO_DAYS() in exact terms by specifying the year, month, day, and time.

This is not really possible, as this happened in different countries on different dates.
But we have a page in the manual that describes exactly what calendar is used in MySQL and what that paragraph that you quoted means. Check

http://dev.mysql.com/doc/mysql/en/mysql-calendar.html

Thanks Sergei, I read the documentation you recommended. But I stilll don't know what this "advent" is.Assuming it is some day rather than a splist second moment, I still do'nt know wheter FROM_DAYS is valid exectly up to, or right after that day.

I am trying FROM_DAYS(24) and the result is 0000-00-00 instead of being 0000-00-24. IS this the right functionality of this function ? If there is another way to convert from days to yyyy-mm-dd please show me.