File Name: months_on_books.c, years_on_books.c
File Size: 5 kb, 8 kb
Release Date: 6/16/2008 9:29:00 AM
These UDFs implement difference determination in months/years using smaller units of granularity, days/months, to accurately calculate the difference. According to the ANSI SQL standard, units smaller than the unit of the result are to be ignored in an SQL calculation, but this can lead to results not consistent with business practices (Refer to NTA 1553). This distribution contains full source code, REPLACE FUNCTION SQL, a test suite and documentation.
|
|
|
|