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
Triage: D4 (Minor)

[5 Jul 2005 8:46] Roland Bouman
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 ....).
[5 Jul 2005 8:48] Roland Bouman
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.
[17 Jul 2005 19:41] Sergei Golubchik
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
[18 Jul 2005 8:24] Roland Bouman
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.
[25 Jul 2011 10:37] enor nakuci
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.