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: | |
Category: | MySQL Server: Documentation | Severity: | S4 (Feature request) |
Version: | 5.0.7 | OS: | NA |
Assigned to: | Sergei Golubchik | CPU Architecture: | Any |
[5 Jul 2005 8:46]
Roland Bouman
[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.