Gerrit Mantel
 |
Programs | SQL_SCALAR_FUNCTION - fun_year2easter |  |
 |
 |
 |
| Name | fun_year2easter |
| Type_desc | SQL_SCALAR_FUNCTION |
| Comment | SQLServer User-Defined Function PURPOSE Return the date of 1-st easter day of a given year. Other dutch christian holidays are derived from 1-st easter day: - Goede vrijdag = 1-st_easter_day - 2 - 2e Paasdag = 1-st_easter_day + 1 - Hemelvaartsdag = 1-st_easter_day + 39 - 1e Pinksterdag = 1-st_easter_day + 49 - 2e Pinksterdag = 1-st_easter_day + 50 PARAMETERS @yr INT Year (between 1732 and 2299) RETURNS DATETIME Date of 1-st easter day EXAMPLE SELECT dbo.fun_year2easter(2024) 2006-04-16 00:00:00.000 HISTORY 2004-12-07 - Created function 2014-10-21 - Renamed function name from fun_pasen to fun_easter - Translated helptext to english 2024-02-09 - Changed history table TAGS <program> <description>Return the date of 1-st easter day of a given year</description> <generic>1</generic> <author>Gerrit Mantel</author> <created>2004-12-07</created> <lastmodified>2024-02-09</lastmodified> </program> |
| Description | Return the date of 1-st easter day of a given year |
| Minversion | |
| Generic | 1 |
| Author | Gerrit Mantel |
| Created | 2004-12-07 00:00:00 |
| Lastmodified | 2024-02-09 00:00:00 |
| Xp_cmdshell | 0 |
| Ole_automation | 0 |
| Subprogram_cnt | 0 |
| Sourcecode |  |